APPS.HR_FI_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 361: from PER_ALL_ASSIGNMENTS_F

357: l_organization_id number(15);
358:
359: cursor get_scl_id is
360: select SOFT_CODING_KEYFLEX_ID
361: from PER_ALL_ASSIGNMENTS_F
362: where assignment_id = p_assignment_id;
363:
364: cursor get_info_from_scl is
365: select lookups.meaning

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

646:
647: SELECT COUNT(distinct(c.contact_person_id))
648: INTO l_dependent_number
649: FROM per_contact_relationships c
650: WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b
651: WHERE b.assignment_id = p_assignment_id
652: AND p_process_date between b.effective_start_date AND b.effective_end_date
653: )
654: AND c.dependent_flag = 'Y'

Line 707: FROM per_all_assignments_f

703: CURSOR csr_get_soft_coded_kf_id (
704: csr_v_assignment_id NUMBER
705: ) IS
706: SELECT max(SOFT_CODING_KEYFLEX_ID) l_soft_code_kf_id
707: FROM per_all_assignments_f
708: WHERE assignment_id = csr_v_assignment_id;
709:
710: lr_soft_coded_kf_id csr_get_soft_coded_kf_id%ROWTYPE;
711:

Line 781: FROM per_all_assignments_f asg1

777: --
778:
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

Line 782: ,per_all_assignments_f asg2

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

Line 880: , per_all_assignments_f paa

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