APPS.GMS_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

Line 4558: FROM gl_period_statuses gps

4554: END IF; -- Bug 2092791
4555: IF x_time_phased_type_code IN ('N', 'G', 'R') THEN
4556: SELECT TRUNC (gps.end_date)
4557: INTO gl_period_end_date
4558: FROM gl_period_statuses gps
4559: WHERE gps.application_id = 101
4560: AND gps.set_of_books_id = x_set_of_books_id
4561: AND TRUNC (exp_date) BETWEEN gps.start_date AND gps.end_date
4562: AND gps.adjustment_period_flag = 'N';

Line 4602: FROM gl_period_statuses gps

4598: g_error_stage := 'PJTD_J-G';
4599: BEGIN
4600: SELECT TRUNC (gps.end_date)
4601: INTO gs_end_date
4602: FROM gl_period_statuses gps
4603: WHERE gps.application_id = 101
4604: AND gps.set_of_books_id = x_set_of_books_id
4605: AND project_end_date BETWEEN gps.start_date AND gps.end_date
4606: AND gps.adjustment_period_flag = 'N';

Line 4626: FROM gl_period_statuses gps

4622: OR x_boundary_code = 'Y') THEN
4623: g_error_stage := 'Year Start and End Date';
4624: SELECT gps.year_start_date
4625: INTO year_start_date
4626: FROM gl_period_statuses gps
4627: WHERE gps.application_id = 101
4628: AND gps.set_of_books_id = x_set_of_books_id
4629: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4630: AND gps.adjustment_period_flag = 'N';

Line 4641: FROM gl_period_statuses gps

4637: SELECT TRUNC (gps.start_date),
4638: TRUNC (gps.end_date)
4639: INTO gl_period_start_date,
4640: gl_period_end_date
4641: FROM gl_period_statuses gps
4642: WHERE gps.application_id = 101
4643: AND gps.set_of_books_id = x_set_of_books_id
4644: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4645: AND gps.adjustment_period_flag = 'N';

Line 4693: FROM gl_period_statuses gps

4689: SELECT TRUNC (gps.start_date),
4690: TRUNC (gps.end_date)
4691: INTO dr_period_start_date,
4692: dr_period_end_date
4693: FROM gl_period_statuses gps
4694: WHERE gps.application_id = 101
4695: AND gps.set_of_books_id = x_set_of_books_id
4696: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4697: AND gps.adjustment_period_flag = 'N';

Line 4757: FROM gl_period_statuses gps

4753: g_error_stage := 'PJTD2';
4754: BEGIN
4755: SELECT TRUNC (gps.start_date)
4756: INTO gs_start_date
4757: FROM gl_period_statuses gps
4758: WHERE gps.application_id = 101
4759: AND gps.set_of_books_id = x_set_of_books_id
4760: AND project_start_date BETWEEN gps.start_date AND gps.end_date
4761: AND gps.adjustment_period_flag = 'N';