APPS.HR_NO_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 142: l_assignment_number per_assignments_f.assignment_number%TYPE;

138: --
139: -- Declare variables
140: --
141:
142: l_assignment_number per_assignments_f.assignment_number%TYPE;
143: l_effective_date DATE;
144:
145: --
146: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 155: FROM per_assignments_f paf,

151: -- Declare cursors
152: --
153: CURSOR csr_legislation IS
154: SELECT NULL
155: FROM per_assignments_f paf,
156: per_business_groups pbg
157: WHERE paf.person_id = p_person_id
158: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
159: AND pbg.business_group_id = paf.business_group_id

Line 416: (c_assignment_id per_assignments_f.assignment_id%TYPE,

412: a varchar2(100);
413: v_field varchar2(20);
414: --
415: CURSOR check_legislation
416: (c_assignment_id per_assignments_f.assignment_id%TYPE,
417: c_effective_date DATE
418: )
419: IS
420: SELECT bgp.legislation_code

Line 421: FROM per_assignments_f asg,

417: c_effective_date DATE
418: )
419: IS
420: SELECT bgp.legislation_code
421: FROM per_assignments_f asg,
422: per_business_groups bgp
423: WHERE asg.business_group_id = bgp.business_group_id
424: AND asg.assignment_id = c_assignment_id
425: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;