APPS.HR_AU_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 177: l_assignment_number per_assignments_f.assignment_number%TYPE;

173: -- Declare cursors AND local variables
174: --
175: -- Declare variables
176: --
177: l_assignment_number per_assignments_f.assignment_number%TYPE;
178: l_effective_date DATE;
179: --
180: l_business_group_id per_business_groups.business_group_id%TYPE;
181: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 188: FROM per_assignments_f paf,

184: -- Declare cursors
185: --
186: CURSOR csr_legislation IS
187: SELECT NULL
188: FROM per_assignments_f paf,
189: per_business_groups pbg
190: WHERE paf.person_id = p_person_id
191: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
192: AND pbg.business_group_id = paf.business_group_id

Line 483: (c_assignment_id per_assignments_f.assignment_id%TYPE,

479: a varchar2(100);
480:
481: --
482: CURSOR check_legislation
483: (c_assignment_id per_assignments_f.assignment_id%TYPE,
484: c_effective_date DATE
485: )
486: IS
487: SELECT bgp.legislation_code

Line 488: FROM per_assignments_f asg,

484: c_effective_date DATE
485: )
486: IS
487: SELECT bgp.legislation_code
488: FROM per_assignments_f asg,
489: per_business_groups bgp
490: WHERE asg.business_group_id = bgp.business_group_id
491: AND asg.assignment_id = c_assignment_id
492: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;