DBA Data[Home] [Help]

APPS.PAY_DK_LABOR_COST_REPORT dependencies on PAY_RUN_RESULTS

Line 117: pay_run_results prr,

113: per_all_people_f pap,
114: per_all_assignments_f asg,
115: pay_payroll_actions ppa,
116: pay_assignment_actions paa,
117: pay_run_results prr,
118: pay_element_types_f pet
119: WHERE pap.person_id = asg.person_id
120: AND asg.payroll_id = ppa.payroll_id
121: AND asg.assignment_id = paa.assignment_id

Line 155: pay_run_results prr

151: per_all_people_f pap,
152: per_all_assignments_f asg,
153: pay_payroll_actions ppa,
154: pay_assignment_actions paa,
155: pay_run_results prr
156: WHERE pap.person_id = asg.person_id
157: AND pap.current_employee_flag = 'Y'
158: AND asg.payroll_id = ppa.payroll_id
159: AND asg.assignment_id = paa.assignment_id

Line 177: pay_run_results prr1,

173: 1
174: FROM
175: pay_payroll_actions ppa1,
176: pay_assignment_actions paa1,
177: pay_run_results prr1,
178: pay_element_types_f pet
179: WHERE pet.legislation_code = 'DK'
180: AND pet.element_name IN ( 'Employee ATP' , 'Employer ATP' )
181: AND pet.element_type_id = prr1.element_type_id