DBA Data[Home] [Help]

APPS.PAY_CN_EFT dependencies on HR_ORGANIZATION_UNITS

Line 13: g_legal_er_param CONSTANT hr_organization_units.organization_id%TYPE :=

9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=
10: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
11: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=
12: pay_magtape_generic.get_parameter_value('ORG_PAYMENT_METHOD_PARAM');
13: g_legal_er_param CONSTANT hr_organization_units.organization_id%TYPE :=
14: pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER_PARAM');
15:
16:
17:

Line 46: ,hr_organization_units hou

42: ,pay_assignment_actions paa
43: ,pay_org_payment_methods_f opm
44: ,pay_personal_payment_methods_f ppm
45: ,pay_external_accounts pea
46: ,hr_organization_units hou
47: WHERE ppa.payroll_action_id= g_pay_action_param
48: AND paa.payroll_action_id = ppa.payroll_action_id
49: AND ppp.pre_payment_id = paa.pre_payment_id
50: AND opm.org_payment_method_id = ppp.org_payment_method_id

Line 95: ,hr_organization_units hou

91: ,pay_org_payment_methods_f opm
92: ,pay_personal_payment_methods_f ppm
93: ,pay_external_accounts pea
94: ,per_assignments_f paf
95: ,hr_organization_units hou
96: ,per_people_f ppf
97: WHERE ppa.payroll_action_id= g_pay_action_param
98: AND paa.payroll_action_id = ppa.payroll_action_id
99: AND ppp.pre_payment_id = paa.pre_payment_id