APPS.HR_FI_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 241: FROM PER_ALL_PEOPLE_F

237: l_return_value VARCHAR2(150) ;
238:
239: CURSOR c_retire IS
240: SELECT DATE_OF_BIRTH,PER_INFORMATION8
241: FROM PER_ALL_PEOPLE_F
242: WHERE PERSON_ID=p_person_id
243: AND p_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;
244: BEGIN
245: OPEN c_retire;

Line 644: ,per_all_people_f per

640: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE , p_input_value VARCHAR2 ) IS
641: SELECT eev1.screen_entry_value screen_entry_value
642: FROM per_all_assignments_f asg1
643: ,per_all_assignments_f asg2
644: ,per_all_people_f per
645: ,pay_element_links_f el
646: ,pay_element_types_f et
647: ,pay_input_values_f iv1
648: ,pay_element_entries_f ee

Line 740: , per_all_people_f pap1

736: , pap1.per_information12 , pap1.per_information13
737: from HR_ORGANIZATION_UNITS o1
738: , HR_ORGANIZATION_INFORMATION hoi1
739: , HR_ORGANIZATION_INFORMATION hoi2
740: , per_all_people_f pap1
741: , per_all_assignments_f paa
742: WHERE hoi1.organization_id = o1.organization_id
743: and hoi1.org_information1 = 'FI_TRADE_UNION'
744: and hoi1.org_information_context = 'CLASS'