APPS.GHR_SES_CONV_PKG dependencies on PER_ASSIGNMENTS_F

Line 31: l_position_id per_assignments_f.position_id%type;

27:
28: l_user_tab_name pay_user_tables.user_table_name%type
29: := 'ESSL Oracle Federal Standard Pay Table (EP, ES, IE, IP, FE, SL and ST) No. ESSL';
30:
31: l_position_id per_assignments_f.position_id%type;
32: l_essl_tab_id pay_user_tables.user_table_id%type;
33: l_user_tab_id pay_user_tables.user_table_id%type;
34:
35: CURSOR cur_user_pay_tab (l_user_table_name IN pay_user_tables.user_table_name%type)

Line 145: ,per_assignments_f paf

141: CURSOR cur_emp_det IS
142: SELECT per.full_name full_name
143: ,per.national_identifier national_identifier
144: from per_people_f per
145: ,per_assignments_f paf
146: where paf.person_id = per.person_id
147: and l_check_date
148: between paf.effective_start_date and paf.effective_end_date
149: and l_check_date