DBA Data[Home] [Help]

APPS.PAY_NZ_TAX dependencies on PER_ASSIGNMENTS_F

Line 230: -- Changed cursor code as part of performance fix. Added per_assignments_f and used effective_date

226: following cursors c_cs_code_override and c_cs_code */
227:
228: --
229: -- Bug 3181581
230: -- Changed cursor code as part of performance fix. Added per_assignments_f and used effective_date
231: -- instead of regular_payment_date
232: --
233: cursor c_cs_code_override (p_assignment_id number
234: ,p_start_date date

Line 242: , per_assignments_f asg

238: , pay_input_values_f iv
239: , pay_run_results rr
240: , pay_run_result_values rrv
241: , pay_assignment_actions aa
242: , per_assignments_f asg
243: , pay_payroll_actions pa
244: , per_time_periods tp
245: where et.element_name = 'Child Support Information'
246: and iv.element_type_id = et.element_type_id

Line 270: -- Changed cursor code as part of performance fix. Added per_assignments_f and used effective_date

266: pa.action_sequence desc ;
267:
268: --
269: -- Bug 3181581
270: -- Changed cursor code as part of performance fix. Added per_assignments_f and used effective_date
271: -- instead of regular_payment_date
272: --
273: cursor c_cs_code (p_assignment_id number
274: ,p_start_date date

Line 282: , per_assignments_f asg

278: , pay_input_values_f iv
279: , pay_run_results rr
280: , pay_run_result_values rrv
281: , pay_assignment_actions aa
282: , per_assignments_f asg
283: , pay_payroll_actions pa
284: , per_time_periods tp
285: where et.element_name = 'Child Support Deduction'
286: and iv.element_type_id = et.element_type_id