DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_TIME_ENT_PERIOD_V

Line 5793: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

5789: ) curr
5790: , PJI_FM_AGGR_DLY_RATES_T rates
5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5792: UNION ALL
5793: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5794: ) dates
5795: , pji_fm_extr_plnver3_t ver
5796: WHERE 1=1
5797: AND fact.project_id = ver.project_id -- new

Line 5905: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

5901: ) curr
5902: , PJI_FM_AGGR_DLY_RATES_T rates
5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5904: UNION ALL
5905: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5906: ) dates
5907: , pji_fm_extr_plnver3_t ver
5908: WHERE 1=1
5909: AND fact.project_id = ver.project_id -- new

Line 6214: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

6210: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v
6211: UNION ALL
6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6213: UNION ALL
6214: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6215: UNION ALL
6216: SELECT ent_qtr_id, start_date, end_date FROM pji_time_ent_qtr
6217: UNION ALL
6218: SELECT ent_year_id, start_date, end_date FROM pji_time_ent_year