APPS.HR_FI_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 285: FROM PER_ALL_PEOPLE_F

281: l_return_value VARCHAR2(150) ;
282:
283: CURSOR c_retire IS
284: SELECT DATE_OF_BIRTH,PER_INFORMATION8
285: FROM PER_ALL_PEOPLE_F
286: WHERE PERSON_ID=p_person_id
287: AND p_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;
288: BEGIN
289: OPEN c_retire;

Line 783: ,per_all_people_f per

779: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE , p_input_value VARCHAR2 ) IS
780: SELECT eev1.screen_entry_value screen_entry_value
781: FROM per_all_assignments_f asg1
782: ,per_all_assignments_f asg2
783: ,per_all_people_f per
784: ,pay_element_links_f el
785: ,pay_element_types_f et
786: ,pay_input_values_f iv1
787: ,pay_element_entries_f ee

Line 879: , per_all_people_f pap1

875: , pap1.per_information12 , pap1.per_information13
876: from HR_ORGANIZATION_UNITS o1
877: , HR_ORGANIZATION_INFORMATION hoi1
878: , HR_ORGANIZATION_INFORMATION hoi2
879: , per_all_people_f pap1
880: , per_all_assignments_f paa
881: WHERE hoi1.organization_id = o1.organization_id
882: and hoi1.org_information1 = 'FI_TRADE_UNION'
883: and hoi1.org_information_context = 'CLASS'