APPS.CSTPPPSC dependencies on GL_PERIOD_STATUSES

Line 892: FROM gl_period_statuses gps

888: /* **************************************************************************** */
889: CURSOR ap_period_open_cur( p_entity_id NUMBER,
890: p_closing_end_date DATE) IS
891: SELECT count(1)
892: FROM gl_period_statuses gps
893: WHERE gps.application_id = 200
894: AND gps.closing_status <> 'C'
895: AND trunc(gps.end_date) <= trunc(p_closing_end_date)
896: AND gps.set_of_books_id = ( SELECT max(gll.ledger_id)

Line 1772: FROM gl_period_statuses gps

1768: --- we do NOT check the AR period of which the start date is earlier than or equals the PAC
1769: --- period close date and the end date is later than the PAC period close date.
1770: SELECT gps.effective_period_num
1771: INTO l_effective_period_num
1772: FROM gl_period_statuses gps
1773: WHERE gps.ledger_id = l_ledger_id
1774: AND gps.application_id = 222
1775: AND gps.adjustment_period_flag = 'N' -- Added for bug#4634513
1776: AND trunc(gps.end_date) =

Line 1779: FROM gl_period_statuses gps

1775: AND gps.adjustment_period_flag = 'N' -- Added for bug#4634513
1776: AND trunc(gps.end_date) =
1777: (
1778: SELECT max(trunc(gps.end_date))
1779: FROM gl_period_statuses gps
1780: WHERE gps.ledger_id = l_ledger_id
1781: AND gps.application_id = 222
1782: AND gps.adjustment_period_flag = 'N' -- Added for bug#4634513
1783: AND trunc(closing_end_date) >= trunc(gps.end_date)

Line 1789: FROM gl_period_statuses gps

1785: else
1786: --- otherwise, check the overlapping AR period or the latest AR period, whichever is later.
1787: SELECT gps.effective_period_num
1788: INTO l_effective_period_num
1789: FROM gl_period_statuses gps
1790: WHERE gps.ledger_id = l_ledger_id
1791: AND gps.application_id = 222
1792: AND gps.adjustment_period_flag = 'N' -- Added for bug#4634513
1793: AND trunc(closing_end_date) BETWEEN gps.start_date AND gps.end_date;