DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_PERIODS_ALL

Line 2883: , pa_periods_all pa

2879: SELECT MIN(TIM.start_date) first_open
2880: INTO l_report_date
2881: FROM
2882: pji_time_cal_period_v TIM
2883: , pa_periods_all pa
2884: , pa_implementations paimp
2885: WHERE 1=1
2886: AND TIM.calendar_id = x_calendar_id
2887: AND paimp.org_id = pa.org_id

Line 2910: , pa_periods_all pa

2906: SELECT MAX(TIM.start_date) last_open
2907: INTO l_report_date
2908: FROM
2909: pji_time_cal_period_v TIM
2910: , pa_periods_all pa
2911: , pa_implementations paimp
2912: WHERE 1=1
2913: AND TIM.calendar_id = x_calendar_id
2914: AND paimp.org_id = pa.org_id

Line 2937: , pa_periods_all pa

2933: SELECT MAX(TIM.start_date) last_open
2934: INTO l_report_date
2935: FROM
2936: pji_time_cal_period_v TIM
2937: , pa_periods_all pa
2938: , pa_implementations paimp
2939: WHERE 1=1
2940: AND TIM.calendar_id = x_calendar_id
2941: AND paimp.org_id = pa.org_id