APPS.CSTPPPSC dependencies on GL_PERIOD_STATUSES

Line 855: FROM gl_period_statuses gps

851: CURSOR ap_period_open_cur( p_entity_id NUMBER,
852: p_cost_type_id NUMBER,
853: p_closing_end_date DATE) IS
854: SELECT count(1)
855: FROM gl_period_statuses gps
856: WHERE gps.application_id = 200
857: AND gps.closing_status <> 'C'
858: AND trunc(gps.end_date) = trunc(p_closing_end_date)
859: AND gps.set_of_books_id = ( SELECT distinct clct.set_of_books_id

Line 1628: FROM gl_period_statuses

1624: l_stmt_num := 70;
1625: -- Get the effective period number to pass to the AR procedure
1626: SELECT effective_period_num
1627: INTO l_effective_period_num
1628: FROM gl_period_statuses
1629: WHERE ledger_id = l_ledger_id
1630: AND application_id = 101
1631: AND adjustment_period_flag = 'N' -- Added for bug#4634513
1632: AND closing_end_date BETWEEN start_date AND end_date;