DBA Data[Home] [Help]

APPS.PJI_FM_SUM_MAIN dependencies on PJI_FM_DNGL_FIN

Line 133: from PJI_FM_DNGL_FIN;

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

Line 1069: PJI_FM_DNGL_FIN tmp2,

1065: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1066: 'RECVR_PA2', FND_PROFILE.VALUE('PA_SECONDARY_RATE_TYPE')) /* Modified for bug 12979524 */
1067: RATE_TYPE
1068: from
1069: PJI_FM_DNGL_FIN tmp2,
1070: (
1071: select 'RECVR_GL1' INVERT_ID from dual union all
1072: select 'RECVR_GL2' INVERT_ID from dual union all
1073: select 'RECVR_PA1' INVERT_ID from dual union all

Line 1220: PJI_FM_DNGL_FIN tmp2,

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