DBA Data[Home] [Help]

APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on PJI_ORG_EXTR_INFO

Line 788: PJI_ORG_EXTR_INFO info,

784: act5.TXN_CURRENCY_CODE
785: ) src1
786: ) src2,
787: PA_PROJECTS_ALL prj,
788: PJI_ORG_EXTR_INFO info,
789: (
790: select 1 INVERT_ID from dual
791: where l_g1_currency_code is not null union all
792: select 2 INVERT_ID from dual

Line 880: PJI_ORG_EXTR_INFO info

876: from
877: PJI_PJI_PROJ_BATCH_MAP map,
878: PJI_AC_PROJ_F acp,
879: FII_TIME_RPT_STRUCT cal,
880: PJI_ORG_EXTR_INFO info
881: where
882: map.WORKER_ID = p_worker_id and
883: acp.PROJECT_ID = map.PROJECT_ID and
884: cal.REPORT_DATE = trunc(sysdate, 'J') and

Line 957: PJI_ORG_EXTR_INFO info,

953:
954: from
955: PJI_PJI_PROJ_BATCH_MAP map,
956: PJI_AC_PROJ_F acp,
957: PJI_ORG_EXTR_INFO info,
958: FII_TIME_CAL_RPT_STRUCT cal
959: where
960: l_pa_calendar_flag = 'Y' and
961: map.WORKER_ID = p_worker_id and

Line 1038: PJI_ORG_EXTR_INFO info,

1034:
1035: from
1036: PJI_PJI_PROJ_BATCH_MAP map,
1037: PJI_AC_PROJ_F acp,
1038: PJI_ORG_EXTR_INFO info,
1039: PJI_TIME_PA_RPT_STR_MV cal
1040: where
1041: l_pa_calendar_flag = 'Y' and
1042: map.WORKER_ID = p_worker_id and