DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 98: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE ;

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 ;
102: l_assignment_set_name hr_assignment_sets.assignment_set_name%TYPE ;

Line 155: from pay_consolidation_sets

151: and rownum = 1 ;
152: --
153: cursor csr_consolidation_set_name is
154: select consolidation_set_name
155: from pay_consolidation_sets
156: where consolidation_set_id = p_consolidation_set_id ;
157: --
158: cursor csr_assignment_set_name(p_asg_set_id in number) is
159: select assignment_set_name