APPS.HR_IN_ASSIGNMENT_API dependencies on PER_PEOPLE_F

Line 19: (l_person_id per_people_f.person_id%TYPE,

15: IS
16: l_legislation_code per_business_groups.legislation_code%type;
17: --
18: CURSOR csr_emp_leg
19: (l_person_id per_people_f.person_id%TYPE,
20: l_effective_date DATE
21: )
22: IS
23: SELECT bgp.legislation_code

Line 24: FROM per_people_f per,

20: l_effective_date DATE
21: )
22: IS
23: SELECT bgp.legislation_code
24: FROM per_people_f per,
25: per_business_groups bgp
26: WHERE per.business_group_id = bgp.business_group_id
27: AND per.person_id = l_person_id
28: AND l_effective_date between per.effective_start_date and per.effective_END_date;

Line 789: (l_person_id per_people_f.person_id%TYPE,

785: l_proc VARCHAR2(72);
786: l_cwk_check NUMBER;
787:
788: CURSOR csr_cwk_leg
789: (l_person_id per_people_f.person_id%TYPE,
790: l_effective_date DATE,
791: l_business_group_id per_people_f.business_group_id%TYPE
792: )
793: IS

Line 791: l_business_group_id per_people_f.business_group_id%TYPE

787:
788: CURSOR csr_cwk_leg
789: (l_person_id per_people_f.person_id%TYPE,
790: l_effective_date DATE,
791: l_business_group_id per_people_f.business_group_id%TYPE
792: )
793: IS
794: SELECT 1
795: FROM per_people_f

Line 795: FROM per_people_f

791: l_business_group_id per_people_f.business_group_id%TYPE
792: )
793: IS
794: SELECT 1
795: FROM per_people_f
796: WHERE business_group_id = l_business_group_id
797: AND person_id = l_person_id
798: AND l_effective_date between effective_start_date and effective_END_date;
799: BEGIN