DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on GL_PERIOD_STATUSES

Line 767: FROM gl_period_statuses

763: l_message VARCHAR2(2000);
764:
765: CURSOR c_default_gl_period IS
766: SELECT period_name
767: FROM gl_period_statuses
768: WHERE closing_status IN ('O', 'F')
769: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
770: pn_mo_cache_utils.get_current_org_id)
771: AND application_id = 101

Line 1194: FROM gl_period_statuses

1190: ORDER BY pt.payment_term_id ;
1191:
1192: CURSOR C_VALID_PERIOD IS
1193: SELECT 1
1194: FROM gl_period_statuses
1195: WHERE closing_status IN ('O', 'F')
1196: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1197: pn_mo_cache_utils.get_current_org_id)
1198: AND application_id = 101

Line 1948: FROM gl_period_statuses

1944: order by pt.payment_term_id;
1945:
1946: CURSOR C_VALID_PERIOD IS
1947: SELECT 1
1948: FROM gl_period_statuses
1949: WHERE closing_status IN ('O', 'F')
1950: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1951: pn_mo_cache_utils.get_current_org_id)
1952: AND application_id = 101