eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_PAYPROC dependencies on PAY_NO_PAYPROC_UTILITY

Line 92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')

88: WHERE pa1.payroll_action_id = p_payroll_action_id
89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments

Line 93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),

89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
97: AND act.payroll_action_id = pa2.payroll_action_id

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

160:
161: l_proc_name := l_package || 'assignment_action_code';
162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);

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

161: l_proc_name := l_package || 'assignment_action_code';
162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);

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

162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);

Line 167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));

163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);