APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

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 158: l_person_id per_all_people_f.person_id%TYPE;

154: ,P_PEI_INFORMATION9 in VARCHAR2)
155:
156: is
157: l_filing_status_code varchar2(2);
158: l_person_id per_all_people_f.person_id%TYPE;
159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/

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: