DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on HR_ASSIGNMENT_SETS

Line 99: l_retro_assignment_set_name hr_assignment_sets.assignment_set_name%TYPE ;

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 ;
103: l_payment_method_override_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;

Line 102: l_assignment_set_name hr_assignment_sets.assignment_set_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 ;
103: l_payment_method_override_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
104: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
105: l_business_place_name hr_all_organization_units.name%TYPE ;
106: l_retro_notf_event_group_name pay_event_groups.event_group_name%TYPE ;

Line 160: from hr_assignment_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
160: from hr_assignment_sets
161: where assignment_set_id = p_asg_set_id ;
162: --
163: cursor csr_element_set_name(p_ele_set_id in number) is
164: select element_set_name