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 149: ,per_assignments_f paf

145: ,per.national_identifier national_identifier
146: --bug # 9329643
147: ,per.employee_number employee_number
148: from per_people_f per
149: ,per_assignments_f paf
150: where paf.person_id = per.person_id
151: and l_check_date
152: between paf.effective_start_date and paf.effective_end_date
153: and l_check_date