APPS.GHR_SF52_UPDATE dependencies on PAY_USER_TABLES

Line 46: from pay_user_tables

42: and equivalent_pay_plan = 'GS';
43:
44: CURSOR C4 is
45: select SUBSTR(user_table_name,0,4)
46: from pay_user_tables
47: where user_table_id = p_to_pay_table_identifier;
48:
49: -- Bug# 7269520 Added the below cursor to check pay plan
50: -- and valid grade combination for auto population of P11 remarks

Line 76: l_user_table_name pay_user_tables.user_table_name%type;

72: l_remark c2%rowtype;
73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
74: l_object_version_number ghr_pa_remarks.object_version_number%type;
75: l_description ghr_remarks.description%type;
76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);
79: -- Bug # 7269520
80: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;