DBA Data[Home] [Help]

APPS.PAY_DK_LABOR_COST_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 114: per_all_assignments_f asg,

110: MAX(pap.date_of_birth) date_of_birth, --9059957
111: MAX(asg.payroll_id) payroll_id --9059957
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

Line 152: per_all_assignments_f asg,

148: asg.assignment_id assignment_id,
149: max(paa.assignment_action_id) assignment_action_id
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