APPS.GMS_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

Line 4204: FROM gl_period_statuses gps

4200: END IF; -- Bug 2092791
4201: IF x_time_phased_type_code IN ('N', 'G', 'R') THEN
4202: SELECT TRUNC (gps.end_date)
4203: INTO gl_period_end_date
4204: FROM gl_period_statuses gps
4205: WHERE gps.application_id = 101
4206: AND gps.set_of_books_id = x_set_of_books_id
4207: AND TRUNC (exp_date) BETWEEN gps.start_date AND gps.end_date
4208: AND gps.adjustment_period_flag = 'N';

Line 4248: FROM gl_period_statuses gps

4244: g_error_stage := 'PJTD_J-G';
4245: BEGIN
4246: SELECT TRUNC (gps.end_date)
4247: INTO gs_end_date
4248: FROM gl_period_statuses gps
4249: WHERE gps.application_id = 101
4250: AND gps.set_of_books_id = x_set_of_books_id
4251: AND project_end_date BETWEEN gps.start_date AND gps.end_date
4252: AND gps.adjustment_period_flag = 'N';

Line 4272: FROM gl_period_statuses gps

4268: OR x_boundary_code = 'Y') THEN
4269: g_error_stage := 'Year Start and End Date';
4270: SELECT gps.year_start_date
4271: INTO year_start_date
4272: FROM gl_period_statuses gps
4273: WHERE gps.application_id = 101
4274: AND gps.set_of_books_id = x_set_of_books_id
4275: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4276: AND gps.adjustment_period_flag = 'N';

Line 4287: FROM gl_period_statuses gps

4283: SELECT TRUNC (gps.start_date),
4284: TRUNC (gps.end_date)
4285: INTO gl_period_start_date,
4286: gl_period_end_date
4287: FROM gl_period_statuses gps
4288: WHERE gps.application_id = 101
4289: AND gps.set_of_books_id = x_set_of_books_id
4290: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4291: AND gps.adjustment_period_flag = 'N';

Line 4339: FROM gl_period_statuses gps

4335: SELECT TRUNC (gps.start_date),
4336: TRUNC (gps.end_date)
4337: INTO dr_period_start_date,
4338: dr_period_end_date
4339: FROM gl_period_statuses gps
4340: WHERE gps.application_id = 101
4341: AND gps.set_of_books_id = x_set_of_books_id
4342: AND TRUNC (x_expenditure_item_date) BETWEEN gps.start_date AND gps.end_date
4343: AND gps.adjustment_period_flag = 'N';

Line 4403: FROM gl_period_statuses gps

4399: g_error_stage := 'PJTD2';
4400: BEGIN
4401: SELECT TRUNC (gps.start_date)
4402: INTO gs_start_date
4403: FROM gl_period_statuses gps
4404: WHERE gps.application_id = 101
4405: AND gps.set_of_books_id = x_set_of_books_id
4406: AND project_start_date BETWEEN gps.start_date AND gps.end_date
4407: AND gps.adjustment_period_flag = 'N';