DBA Data[Home] [Help]

APPS.PAY_DK_LABOR_COST_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 116: pay_assignment_actions paa,

112: FROM
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

Line 154: pay_assignment_actions paa,

150: FROM
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

Line 176: pay_assignment_actions paa1,

172: SELECT
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' )

Line 231: pay_assignment_actions paa

227: SELECT
228: max(paa.assignment_action_id) assignment_action_id
229: FROM
230: pay_payroll_actions ppa,
231: pay_assignment_actions paa
232: WHERE paa.assignment_id = p_assignment_id
233: AND paa.tax_unit_id = p_legal_employer_id
234: AND ppa.payroll_action_id = paa.payroll_action_id
235: AND ppa.action_type IN ( 'R' , 'B' , 'I' , 'Q' , 'V' )