APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_PERIODS

Line 7319: FROM pa_periods gpa

7315: SELECT TRUNC ( start_date ),
7316: TRUNC ( end_date )
7317: INTO l_pa_period_start_date,
7318: l_pa_period_end_date
7319: FROM pa_periods gpa
7320: WHERE p_expenditure_item_date BETWEEN gpa.start_date AND gpa.end_date;
7321: ELSIF p_time_phase_type_code = 'R' THEN
7322: -- FOR DATE RANGE
7323: g_error_stage := 'Time Phase R';

Line 7370: FROM pa_periods gpa

7366: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>' PJTD- P');
7367: BEGIN
7368: SELECT TRUNC ( start_date )
7369: INTO l_gs_start_date
7370: FROM pa_periods gpa
7371: WHERE l_project_start_date BETWEEN gpa.start_date AND gpa.end_date;
7372: EXCEPTION
7373: WHEN NO_DATA_FOUND THEN
7374: SELECT TRUNC ( MIN ( start_date ))

Line 7428: FROM pa_periods gpa

7424: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD_J-P');
7425: BEGIN
7426: SELECT TRUNC ( end_date )
7427: INTO l_gs_end_date
7428: FROM pa_periods gpa
7429: WHERE l_project_end_date BETWEEN gpa.start_date AND gpa.end_date;
7430: EXCEPTION
7431: WHEN NO_DATA_FOUND THEN
7432: SELECT TRUNC ( MAX ( end_date ))

Line 7483: FROM pa_periods p

7479: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-Y-P');
7480: BEGIN
7481: SELECT p.end_date
7482: INTO l_gs_end_date
7483: FROM pa_periods p
7484: WHERE l_year_end_date BETWEEN p.start_date AND p.end_date;
7485: x_end_date := l_gs_end_date;
7486: EXCEPTION
7487: WHEN NO_DATA_FOUND THEN

Line 7534: FROM pa_periods p

7530: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'YTD1-P');
7531: BEGIN
7532: SELECT p.start_date
7533: INTO l_gs_start_date
7534: FROM pa_periods p
7535: WHERE l_year_start_date BETWEEN p.start_date AND p.end_date;
7536: x_start_date := l_gs_start_date;
7537: EXCEPTION
7538: WHEN NO_DATA_FOUND THEN

Line 7564: FROM pa_periods p

7560: (p_msg_token1 =>'YTD-Y-P');
7561: BEGIN
7562: SELECT p.end_date
7563: INTO l_gs_end_date
7564: FROM pa_periods p
7565: WHERE l_year_end_date BETWEEN p.start_date AND p.end_date;
7566: x_end_date := l_gs_end_date;
7567: EXCEPTION
7568: WHEN NO_DATA_FOUND THEN