APPS.PAY_IN_EFT dependencies on HR_ORGANIZATION_UNITS

Line 16: g_reg_er_param CONSTANT hr_organization_units.organization_id%TYPE :=

12: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
13: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
15: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
16: g_reg_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
17: pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER_PARAM');
18:
19: --Cursor to retrieve Header Info
20: CURSOR c_eft_header IS

Line 56: , hr_organization_units org

52: , pay_assignment_actions paa
53: , pay_payroll_actions ppa
54: , per_assignments_f asg
55: , per_people_f per
56: , hr_organization_units org
57: , hr_organization_information hoi
58: , hr_organization_units hou
59: , pay_payment_types ppto
60: WHERE ppa.payroll_action_id = g_pay_action_param

Line 58: , hr_organization_units hou

54: , per_assignments_f asg
55: , per_people_f per
56: , hr_organization_units org
57: , hr_organization_information hoi
58: , hr_organization_units hou
59: , pay_payment_types ppto
60: WHERE ppa.payroll_action_id = g_pay_action_param
61: AND ppp.pre_payment_id = paa.pre_payment_id
62: AND paa.payroll_action_id = ppa.payroll_action_id

Line 132: , hr_organization_units org

128: , pay_assignment_actions paa
129: , pay_payroll_actions ppa
130: , per_assignments_f asg
131: , per_people_f per
132: , hr_organization_units org
133: , pay_payment_types ppto
134: WHERE ppa.payroll_action_id = g_pay_action_param
135: AND ppp.pre_payment_id = paa.pre_payment_id
136: AND paa.payroll_action_id = ppa.payroll_action_id