APPS.HR_SE_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 135: l_assignment_number per_assignments_f.assignment_number%TYPE;

131: --
132: -- Declare variables
133: --
134:
135: l_assignment_number per_assignments_f.assignment_number%TYPE;
136: l_effective_date DATE;
137: --
138: l_business_group_id per_business_groups.business_group_id%TYPE;
139: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 147: FROM per_assignments_f paf,

143: -- Declare cursors
144: --
145: CURSOR csr_legislation IS
146: SELECT NULL
147: FROM per_assignments_f paf,
148: per_business_groups pbg
149: WHERE paf.person_id = p_person_id
150: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
151: AND pbg.business_group_id = paf.business_group_id

Line 395: (c_assignment_id per_assignments_f.assignment_id%TYPE,

391: a varchar2(100);
392: v_field varchar2(20);
393: --
394: CURSOR check_legislation
395: (c_assignment_id per_assignments_f.assignment_id%TYPE,
396: c_effective_date DATE
397: )
398: IS
399: SELECT bgp.legislation_code

Line 400: FROM per_assignments_f asg,

396: c_effective_date DATE
397: )
398: IS
399: SELECT bgp.legislation_code
400: FROM per_assignments_f asg,
401: per_business_groups bgp
402: WHERE asg.business_group_id = bgp.business_group_id
403: AND asg.assignment_id = c_assignment_id
404: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;