APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_PERIODS

Line 4571: FROM pa_periods gpa

4567: END IF;
4568: ELSIF x_time_phased_type_code = 'P' THEN
4569: SELECT TRUNC (end_date)
4570: INTO pa_period_end_date
4571: FROM pa_periods gpa
4572: WHERE TRUNC (exp_date) BETWEEN gpa.start_date AND gpa.end_date;
4573: IF pa_period_end_date > gb_end_date THEN
4574: project_end_date := pa_period_end_date;
4575: ELSE

Line 4585: FROM pa_periods gpa

4581: g_error_stage := 'PJTD_J-P';
4582: BEGIN
4583: SELECT TRUNC (end_date)
4584: INTO gs_end_date
4585: FROM pa_periods gpa
4586: WHERE project_end_date BETWEEN gpa.start_date AND gpa.end_date;
4587: EXCEPTION
4588: WHEN NO_DATA_FOUND THEN
4589: SELECT TRUNC (MAX (end_date))

Line 4657: FROM pa_periods gpa

4653: SELECT TRUNC (start_date),
4654: TRUNC (end_date)
4655: INTO pa_period_start_date,
4656: pa_period_end_date
4657: FROM pa_periods gpa
4658: WHERE TRUNC (x_expenditure_item_date) BETWEEN gpa.start_date AND gpa.end_date;
4659: ELSIF x_time_phased_type_code = 'R' THEN -- FOR DATE RANGE
4660: g_error_stage := 'Time Phase R';
4661: /* ====================================================

Line 4740: FROM pa_periods gpa

4736: g_error_stage := 'PJTD1';
4737: BEGIN
4738: SELECT TRUNC (start_date)
4739: INTO gs_start_date
4740: FROM pa_periods gpa
4741: WHERE project_start_date BETWEEN gpa.start_date AND gpa.end_date;
4742: EXCEPTION
4743: WHEN NO_DATA_FOUND THEN
4744: SELECT TRUNC (MIN (start_date))

Line 4803: FROM pa_periods p

4799: g_error_stage := 'PJTD-Y-P';
4800: BEGIN
4801: SELECT p.end_date
4802: INTO gs_end_date
4803: FROM pa_periods p
4804: WHERE year_end_date BETWEEN p.start_date AND p.end_date;
4805: x_end_date := gs_end_date;
4806: EXCEPTION
4807: WHEN NO_DATA_FOUND THEN

Line 4852: FROM pa_periods p

4848: g_error_stage := 'YTD1';
4849: BEGIN
4850: SELECT p.start_date
4851: INTO gs_start_date
4852: FROM pa_periods p
4853: WHERE year_start_date BETWEEN p.start_date AND p.end_date;
4854: x_start_date := gs_start_date;
4855: EXCEPTION
4856: WHEN NO_DATA_FOUND THEN

Line 4873: FROM pa_periods p

4869: g_error_stage := 'YTD-Y-P';
4870: BEGIN
4871: SELECT p.end_date
4872: INTO gs_end_date
4873: FROM pa_periods p
4874: WHERE year_end_date BETWEEN p.start_date AND p.end_date;
4875: x_end_date := gs_end_date;
4876: EXCEPTION
4877: WHEN NO_DATA_FOUND THEN