APPS.GHR_MSL_PKG dependencies on PAY_USER_TABLES

Line 337: SELECT 1 from pay_user_tables

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

Line 2616: from pay_user_tables

2612:
2613: FUNCTION GET_USER_TABLE_name (P_USER_TABLE_id IN NUMBER) RETURN VARCHAR2 IS
2614: CURSOR MSL_CUR IS
2615: select user_table_id,substr(user_table_name,0,4) user_table_name
2616: from pay_user_tables
2617: where substr(user_table_name,6,14) in
2618: ('Oracle Federal','Federal Agency')
2619: and user_table_id = p_user_table_id;
2620: l_user_table_name varchar2(80);

Line 5231: select 1 from pay_user_tables

5227:
5228: l_proc varchar2(72) := g_package || '.execute_msl_perc';
5229:
5230: cursor c_pay_tab_essl is
5231: select 1 from pay_user_tables
5232: where substr(user_table_name,1,4) = 'ESSL'
5233: and user_table_id = l_user_table_id;
5234:
5235: l_essl_table BOOLEAN := FALSE;

Line 7378: select 1 from pay_user_tables

7374:
7375: l_proc varchar2(72) := g_package || '.execute_msl_ses_range';
7376:
7377: cursor c_pay_tab_essl is
7378: select 1 from pay_user_tables
7379: where substr(user_table_name,1,4) = 'ESSL'
7380: and user_table_id = l_user_table_id;
7381:
7382: l_essl_table BOOLEAN := FALSE;