APPS.GHR_MSL_PKG dependencies on PAY_USER_TABLES

Line 333: SELECT 1 from pay_user_tables

329:
330: -- Bug#5063304 Moved the following cursor, variable declaration
331: -- from execute_msl.
332: CURSOR c_pay_tab_essl IS
333: SELECT 1 from pay_user_tables
334: WHERE substr(user_table_name,1,4) = 'ESSL'
335: AND user_table_id = l_user_table_id;
336:
337: l_essl_table BOOLEAN := FALSE;

Line 2588: from pay_user_tables

2584:
2585: FUNCTION GET_USER_TABLE_name (P_USER_TABLE_id IN NUMBER) RETURN VARCHAR2 IS
2586: CURSOR MSL_CUR IS
2587: select user_table_id,substr(user_table_name,0,4) user_table_name
2588: from pay_user_tables
2589: where substr(user_table_name,6,14) in
2590: ('Oracle Federal','Federal Agency')
2591: and user_table_id = p_user_table_id;
2592: l_user_table_name varchar2(80);

Line 5169: select 1 from pay_user_tables

5165:
5166: l_proc varchar2(72) := g_package || '.execute_msl_perc';
5167:
5168: cursor c_pay_tab_essl is
5169: select 1 from pay_user_tables
5170: where substr(user_table_name,1,4) = 'ESSL'
5171: and user_table_id = l_user_table_id;
5172:
5173: l_essl_table BOOLEAN := FALSE;

Line 7232: select 1 from pay_user_tables

7228:
7229: l_proc varchar2(72) := g_package || '.execute_msl_ses_range';
7230:
7231: cursor c_pay_tab_essl is
7232: select 1 from pay_user_tables
7233: where substr(user_table_name,1,4) = 'ESSL'
7234: and user_table_id = l_user_table_id;
7235:
7236: l_essl_table BOOLEAN := FALSE;