APPS.PJI_RM_SUM_MAIN dependencies on PJI_ORG_EXTR_INFO

Line 1071: PJI_ORG_EXTR_INFO info,

1067: 'G1', PJI_UTILS.GET_RATE_TYPE,
1068: 'G2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE')) RATE_TYPE
1069: from
1070: PJI_FM_EXTR_PLN_LOG log,
1071: PJI_ORG_EXTR_INFO info,
1072: (
1073: select 'G1' INVERT_ID from dual union all
1074: select 'G2' INVERT_ID from dual
1075: ) invert

Line 1114: PJI_ORG_EXTR_INFO info,

1110: 'EN', info.EN_CALENDAR_MAX_DATE,
1111: 'GL', info.GL_CALENDAR_MAX_DATE,
1112: 'PA', info.PA_CALENDAR_MAX_DATE) CALENDAR_MAX_DATE
1113: from
1114: PJI_ORG_EXTR_INFO info,
1115: (
1116: select 'EN' INVERT_ID from dual union all
1117: select 'GL' INVERT_ID from dual union all
1118: select 'PA' INVERT_ID from dual

Line 1164: PJI_ORG_EXTR_INFO info,

1160: end CALENDAR_MAX_DATE,
1161: to_date(to_char(min(tmp1.FROM_TIME_ID)), 'J') FROM_DATE,
1162: to_date(to_char(max(tmp1.TO_TIME_ID)), 'J') TO_DATE
1163: from
1164: PJI_ORG_EXTR_INFO info,
1165: (
1166: select
1167: distinct
1168: tmp1.EXPENDITURE_ORG_ID ORG_ID,