1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
SELECT ID_PLAN_PL
,ID_DROIT_PL
,DATE_ACCEPT_PL
,ID_SEQ_PLAN_PLS
,SEQ_PLAN_PLS
,DATE_PAIEM_PLS
,MONT_SEQ_PLS
,C.y
FROM DBARP.CI_PLAN_RP
,DBARP.CI_PLANSEQ_RP A
,(select '50' y from dual) C
,(select MIN(B.SEQ_PLAN_PLS) x
From DBARP.CI_PLANSEQ_RP B
WHERE B.ID_PLAN_PL_PLS = (SELECT ID_PLAN_DA FROM DBARP.CI_DOSS_ADM_RP WHERE ID_DROIT_DA = 1000555005)
AND B.DATE_PAIEM_PLS IS NULL )
WHERE DATE_ACCEPT_PL IS NOT NULL
AND ID_DROIT_PL = 1000555005
AND A.ID_PLAN_PL_PLS = ID_PLAN_PL
AND A.SEQ_PLAN_PLS =y(+) |
Partager