APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);
43: l_student per_people_extra_info.pei_information1%TYPE;
44: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
45:

Line 58: FROM per_all_assignments_f paf ,per_all_people_f ppf

54:
55:
56: CURSOR get_assignment_id(p_person_id NUMBER) is
57: SELECT distinct assignment_id
58: FROM per_all_assignments_f paf ,per_all_people_f ppf
59: WHERE paf.person_id=ppf.person_id
60: and ppf.person_id=p_person_id
61: and paf.primary_flag='Y';
62:

Line 172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);
174: l_student per_people_extra_info.pei_information1%TYPE;
175: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
176:

Line 189: FROM per_all_assignments_f paf ,per_all_people_f ppf

185:
186: CURSOR get_assignment_id(p_person_id NUMBER)
187: IS
188: SELECT distinct assignment_id
189: FROM per_all_assignments_f paf ,per_all_people_f ppf
190: WHERE paf.person_id=ppf.person_id
191: and ppf.person_id=p_person_id
192: and paf.primary_flag='Y';
193: