APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 97: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

93: l_archive_end_date_hd varchar2(200) ; -- legislative, for payslip archive
94: l_business_group_hd varchar2(200) ; -- legislative, for payslip archive
95: l_hr_payroll_contact_source varchar2(80) ; -- has either GRE/PAYROLL/CUSTOM, depending on which we look for the performer
96: l_performer_name fnd_user.user_name%TYPE ;
97: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
98: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE ;
99: l_retro_assignment_set_name hr_assignment_sets.assignment_set_name%TYPE ;
100: l_retro_element_set_name pay_element_sets.element_set_name%TYPE ;
101: l_element_set_name pay_element_sets.element_set_name%TYPE ;

Line 149: from pay_all_payrolls_f

145: where payment_type_name = 'KR Direct Deposit' ;
146: --
147: cursor csr_payroll_name is
148: select payroll_name
149: from pay_all_payrolls_f
150: where payroll_id = p_payroll_id
151: and rownum = 1 ;
152: --
153: cursor csr_consolidation_set_name is