DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_TIME_ENT_PERIOD_V

Line 5894: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

5890: ) curr
5891: , PJI_FM_AGGR_DLY_RATES_T rates
5892: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5893: UNION ALL
5894: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5895: ) dates
5896: , pji_fm_extr_plnver3_t ver
5897: WHERE 1=1
5898: AND fact.project_id = ver.project_id -- new

Line 6006: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

6002: ) curr
6003: , PJI_FM_AGGR_DLY_RATES_T rates
6004: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6005: UNION ALL
6006: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6007: ) dates
6008: , pji_fm_extr_plnver3_t ver
6009: WHERE 1=1
6010: AND fact.project_id = ver.project_id -- new

Line 6315: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v

6311: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v
6312: UNION ALL
6313: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v
6314: UNION ALL
6315: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6316: UNION ALL
6317: SELECT ent_qtr_id, start_date, end_date FROM pji_time_ent_qtr
6318: UNION ALL
6319: SELECT ent_year_id, start_date, end_date FROM pji_time_ent_year