DBA Data[Home] [Help]

APPS.PJI_RM_SUM_MAIN dependencies on PJI_FM_EXTR_PLN_LOG

Line 1070: PJI_FM_EXTR_PLN_LOG log,

1066: decode(invert.INVERT_ID,
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

Line 1097: PJI_FM_EXTR_PLN_LOG log,

1093: to_date(info.CALENDAR_MAX_DATE, 'J') CALENDAR_MAX_DATE,
1094: min(log.FROM_DATE) FROM_DATE,
1095: max(log.TO_DATE) TO_DATE
1096: from
1097: PJI_FM_EXTR_PLN_LOG log,
1098: (
1099: select
1100: distinct
1101: decode(invert.INVERT_ID,