APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 87: FROM pay_all_payrolls_f

83: --
84: CURSOR csr_get_payroll_name(cpayroll_id NUMBER
85: ,ceffective_date DATE) IS
86: SELECT payroll_name
87: FROM pay_all_payrolls_f
88: WHERE payroll_id = cpayroll_id
89: AND ceffective_date BETWEEN effective_start_date AND effective_end_date;
90: --
91: CURSOR csr_get_person_name(cperson_id NUMBER

Line 100: lpayroll_id pay_all_payrolls_f.payroll_id%TYPE;

96: AND ceffective_date BETWEEN effective_start_date AND effective_end_date;
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);

Line 103: lpayroll_name pay_all_payrolls_f.payroll_name%TYPE;

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;
106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;
107: BEGIN