APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SETS

Line 101: lassignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

97: --
98: leffective_date DATE;
99: lreporting_date DATE;
100: lpayroll_id pay_all_payrolls_f.payroll_id%TYPE;
101: lassignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
102: lperson_id per_all_people_f.person_id%TYPE;
103: lpayroll_name pay_all_payrolls_f.payroll_name%TYPE;
104: lreturn_val VARCHAR2(400);
105: lfull_name per_all_people_f.full_name%TYPE;

Line 292: FROM hr_assignment_sets has

288: --
289: CURSOR csr_incl_excl(c_assignment_id NUMBER
290: ,c_assignment_set_id NUMBER) IS
291: SELECT 1
292: FROM hr_assignment_sets has
293: ,per_all_assignments_f paa
294: WHERE has.assignment_set_id = NVL(c_assignment_set_id, has.assignment_set_id)
295: AND paa.assignment_id = c_assignment_id
296: AND NVL(paa.payroll_id,0) = NVL(has.payroll_id,NVL(paa.payroll_id,0))