DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_NO_PAYPROC_UTILITY

Line 135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter

131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter
136: (pa1.payroll_action_id,'LEGAL_EMPLOYER'))
137: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
138: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
139: and hoi1.organization_id = hoi2.organization_id

Line 155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));

151:
152: l_proc_name := l_package || 'assignment_action_code';
153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);

Line 156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));

152: l_proc_name := l_package || 'assignment_action_code';
153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);
160:

Line 157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));

153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);
160:
161: FOR rec_asg IN csr_asg(p_payroll_action_id