242: from
243: per_assignments_f paa,
244: pay_payroll_actions ppa,
245: per_people_f pap,
246: hr_organization_units hou,
247: hr_organization_units hou1,
248: hr_organization_information hoi,
249: pay_assignment_actions asg_act
250: where
243: per_assignments_f paa,
244: pay_payroll_actions ppa,
245: per_people_f pap,
246: hr_organization_units hou,
247: hr_organization_units hou1,
248: hr_organization_information hoi,
249: pay_assignment_actions asg_act
250: where
251: ppa.business_group_id=p_bg_id
842: from
843: per_assignments_f paa,
844: pay_payroll_actions ppa,
845: per_people_f pap,
846: hr_organization_units hou,
847: hr_organization_units hou1,
848: hr_organization_information hoi,
849: pay_assignment_actions asg_act
850: where
843: per_assignments_f paa,
844: pay_payroll_actions ppa,
845: per_people_f pap,
846: hr_organization_units hou,
847: hr_organization_units hou1,
848: hr_organization_information hoi,
849: pay_assignment_actions asg_act
850: where
851: ppa.business_group_id=p_bg_id