APPS.PN_CREATE_ACC dependencies on GL_PERIOD_STATUSES

Line 255: FROM gl_period_statuses

251: l_ledger_id NUMBER;
252:
253: CURSOR sts_csr (l_ledger_id NUMBER) IS
254: SELECT closing_status
255: FROM gl_period_statuses
256: WHERE application_id = 101
257: AND ledger_id = l_ledger_id
258: AND period_name = p_period_name;
259:

Line 309: FROM gl_period_statuses

305: AS
306:
307: CURSOR aft_csr (l_ledger_id NUMBER) IS
308: SELECT MIN(start_date)
309: FROM gl_period_statuses
310: WHERE application_id = 101
311: AND ledger_id = l_ledger_id
312: AND closing_status IN ('F','O')
313: AND TRUNC(start_date) >= TRUNC(p_gl_date)

Line 320: l_period_status gl_period_statuses.closing_status%TYPE;

316: l_period_name gl_periods.period_name%TYPE;
317: l_start_date DATE;
318: l_end_date DATE;
319: l_dummy_date DATE := NULL;
320: l_period_status gl_period_statuses.closing_status%TYPE;
321: l_ledger_id NUMBER;
322:
323: BEGIN
324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');

Line 1235: FROM gl_period_statuses

1231: l_message VARCHAR2(2000);
1232:
1233: CURSOR c_default_gl_period IS
1234: SELECT period_name
1235: FROM gl_period_statuses
1236: WHERE closing_status IN ('O', 'F')
1237: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1238: pn_mo_cache_utils.get_current_org_id)
1239: AND application_id = 101

Line 1662: FROM gl_period_statuses

1658: ORDER BY pt.payment_term_id ;
1659:
1660: CURSOR C_VALID_PERIOD IS
1661: SELECT 1
1662: FROM gl_period_statuses
1663: WHERE closing_status IN ('O', 'F')
1664: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1665: pn_mo_cache_utils.get_current_org_id)
1666: AND application_id = 101

Line 2416: FROM gl_period_statuses

2412: order by pt.payment_term_id;
2413:
2414: CURSOR C_VALID_PERIOD IS
2415: SELECT 1
2416: FROM gl_period_statuses
2417: WHERE closing_status IN ('O', 'F')
2418: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2419: pn_mo_cache_utils.get_current_org_id)
2420: AND application_id = 101