DBA Data[Home] [Help]

APPS.PJI_FM_SUM_MAIN dependencies on PJI_ORG_EXTR_INFO

Line 1016: PJI_ORG_EXTR_INFO info,

1012: info.PF_CURRENCY_CODE,
1013: tmp2.G_CURRENCY_CODE,
1014: tmp2.RATE_TYPE
1015: from
1016: PJI_ORG_EXTR_INFO info,
1017: (
1018: select
1019: distinct
1020: tmp2.PROJECT_ORG_ID ORG_ID,

Line 1164: PJI_ORG_EXTR_INFO info,

1160: 'P', info.PA_CALENDAR_MAX_DATE), 'J') CALENDAR_MAX_DATE,
1161: to_date(to_char(min(tmp2.FROM_TIME_ID)), 'J') FROM_DATE,
1162: to_date(to_char(max(tmp2.TO_TIME_ID)), 'J') TO_DATE
1163: from
1164: PJI_ORG_EXTR_INFO info,
1165: (
1166: select
1167: distinct
1168: decode(invert.INVERT_ID,