APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_PERIODS

Line 4217: FROM pa_periods gpa

4213: END IF;
4214: ELSIF x_time_phased_type_code = 'P' THEN
4215: SELECT TRUNC (end_date)
4216: INTO pa_period_end_date
4217: FROM pa_periods gpa
4218: WHERE TRUNC (exp_date) BETWEEN gpa.start_date AND gpa.end_date;
4219: IF pa_period_end_date > gb_end_date THEN
4220: project_end_date := pa_period_end_date;
4221: ELSE

Line 4231: FROM pa_periods gpa

4227: g_error_stage := 'PJTD_J-P';
4228: BEGIN
4229: SELECT TRUNC (end_date)
4230: INTO gs_end_date
4231: FROM pa_periods gpa
4232: WHERE project_end_date BETWEEN gpa.start_date AND gpa.end_date;
4233: EXCEPTION
4234: WHEN NO_DATA_FOUND THEN
4235: SELECT TRUNC (MAX (end_date))

Line 4303: FROM pa_periods gpa

4299: SELECT TRUNC (start_date),
4300: TRUNC (end_date)
4301: INTO pa_period_start_date,
4302: pa_period_end_date
4303: FROM pa_periods gpa
4304: WHERE TRUNC (x_expenditure_item_date) BETWEEN gpa.start_date AND gpa.end_date;
4305: ELSIF x_time_phased_type_code = 'R' THEN -- FOR DATE RANGE
4306: g_error_stage := 'Time Phase R';
4307: /* ====================================================

Line 4386: FROM pa_periods gpa

4382: g_error_stage := 'PJTD1';
4383: BEGIN
4384: SELECT TRUNC (start_date)
4385: INTO gs_start_date
4386: FROM pa_periods gpa
4387: WHERE project_start_date BETWEEN gpa.start_date AND gpa.end_date;
4388: EXCEPTION
4389: WHEN NO_DATA_FOUND THEN
4390: SELECT TRUNC (MIN (start_date))

Line 4449: FROM pa_periods p

4445: g_error_stage := 'PJTD-Y-P';
4446: BEGIN
4447: SELECT p.end_date
4448: INTO gs_end_date
4449: FROM pa_periods p
4450: WHERE year_end_date BETWEEN p.start_date AND p.end_date;
4451: x_end_date := gs_end_date;
4452: EXCEPTION
4453: WHEN NO_DATA_FOUND THEN

Line 4498: FROM pa_periods p

4494: g_error_stage := 'YTD1';
4495: BEGIN
4496: SELECT p.start_date
4497: INTO gs_start_date
4498: FROM pa_periods p
4499: WHERE year_start_date BETWEEN p.start_date AND p.end_date;
4500: x_start_date := gs_start_date;
4501: EXCEPTION
4502: WHEN NO_DATA_FOUND THEN

Line 4519: FROM pa_periods p

4515: g_error_stage := 'YTD-Y-P';
4516: BEGIN
4517: SELECT p.end_date
4518: INTO gs_end_date
4519: FROM pa_periods p
4520: WHERE year_end_date BETWEEN p.start_date AND p.end_date;
4521: x_end_date := gs_end_date;
4522: EXCEPTION
4523: WHEN NO_DATA_FOUND THEN