APPS.PA_INTEGRATION_UTILS dependencies on PA_PERIODS_ALL

Line 56: SELECT Trunc(Max(END_DATE))-1 INTO l_end_date FROM pa_periods_all WHERE status <> 'C';

52: BEGIN
53:
54: DELETE FROM pji_fm_xbs_accum_int;
55:
56: SELECT Trunc(Max(END_DATE))-1 INTO l_end_date FROM pa_periods_all WHERE status <> 'C';
57: SELECT trunc(trunc(Max(END_DATE) - Sysdate - 1)) into l_add_days FROM pa_periods_all WHERE status <> 'C';
58:
59: PJI_FM_XBS_ACCUM_UTILS.get_msp_actuals_data
60: (p_project_id => project_id_in,

Line 57: SELECT trunc(trunc(Max(END_DATE) - Sysdate - 1)) into l_add_days FROM pa_periods_all WHERE status <> 'C';

53:
54: DELETE FROM pji_fm_xbs_accum_int;
55:
56: SELECT Trunc(Max(END_DATE))-1 INTO l_end_date FROM pa_periods_all WHERE status <> 'C';
57: SELECT trunc(trunc(Max(END_DATE) - Sysdate - 1)) into l_add_days FROM pa_periods_all WHERE status <> 'C';
58:
59: PJI_FM_XBS_ACCUM_UTILS.get_msp_actuals_data
60: (p_project_id => project_id_in,
61: p_calendar_type => 'A',