APPS.HR_FI_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 317: from PER_ALL_ASSIGNMENTS_F

313: l_organization_id number(15);
314:
315: cursor get_scl_id is
316: select SOFT_CODING_KEYFLEX_ID
317: from PER_ALL_ASSIGNMENTS_F
318: where assignment_id = p_assignment_id;
319:
320: cursor get_info_from_scl is
321: select lookups.meaning

Line 606: WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b

602:
603: SELECT COUNT(distinct(c.contact_person_id))
604: INTO l_dependent_number
605: FROM per_contact_relationships c
606: WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b
607: WHERE b.assignment_id = p_assignment_id
608: AND p_process_date between b.effective_start_date AND b.effective_end_date
609: )
610: AND c.dependent_flag = 'Y'

Line 642: FROM per_all_assignments_f asg1

638: --
639:
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

Line 643: ,per_all_assignments_f asg2

639:
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

Line 741: , per_all_assignments_f paa

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'
745: and hoi2.ORG_INFORMATION_CONTEXT='FI_TRADE_UNION_DETAILS'