DBA Data[Home] [Help]

APPS.PJI_FM_SUM_MAIN dependencies on PJI_FM_DNGL_FIN

Line 132: from PJI_FM_DNGL_FIN;

128: end if;
129:
130: select count(*)
131: into l_row_count
132: from PJI_FM_DNGL_FIN;
133:
134: select count(*) + l_row_count
135: into l_row_count
136: from PJI_FM_DNGL_ACT;

Line 1068: PJI_FM_DNGL_FIN tmp2,

1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1065: 'RECVR_PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1066: RATE_TYPE
1067: from
1068: PJI_FM_DNGL_FIN tmp2,
1069: (
1070: select 'RECVR_GL1' INVERT_ID from dual union all
1071: select 'RECVR_GL2' INVERT_ID from dual union all
1072: select 'RECVR_PA1' INVERT_ID from dual union all

Line 1219: PJI_FM_DNGL_FIN tmp2,

1215: 'PRVDR_PA', tmp2.DANGLING_PRVDR_PA_TIME_FLAG,
1216: 'RECVR_PA', tmp2.DANGLING_RECVR_PA_TIME_FLAG,
1217: 'EXP_PA', tmp2.DANGLING_EXP_PA_TIME_FLAG) DANGLING_FLAG
1218: from
1219: PJI_FM_DNGL_FIN tmp2,
1220: (
1221: select 'PRVDR_EN' INVERT_ID from dual union all
1222: select 'RECVR_EN' INVERT_ID from dual union all
1223: select 'EXP_EN' INVERT_ID from dual union all