APPS.GHR_MASS_CHANGES dependencies on PAY_USER_TABLES

Line 86: l_user_table_id pay_user_tables.user_table_id%type;

82: l_full_name VARCHAR2(380); -- Bug 3718167 --VN
83: l_ssn ghr_pa_requests.employee_national_identifier%TYPE; -- Bug 3718167 --VN
84:
85: ---SES Changes Start
86: l_user_table_id pay_user_tables.user_table_id%type;
87:
88: -- Bug#5089732
89: l_to_grade_id NUMBER;
90: -- Bug#5089732

Line 102: select 1 from pay_user_tables

98: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
99: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
100: --End Bug# 14055214
101: cursor c_pay_tab_essl is
102: select 1 from pay_user_tables
103: where substr(user_table_name,1,4) = 'ESSL'
104: and user_table_id = l_user_table_id;
105:
106: l_essl_table BOOLEAN := FALSE;