DBA Data[Home] [Help]

APPS.PAY_CN_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 9: g_pay_action_param CONSTANT pay_payroll_actions.payroll_action_id%TYPE :=

5: g_start_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('START_DATE_PARAM');
6: g_eff_date_param CONSTANT VARCHAR2(20) := pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE_PARAM');
7: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
8: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
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 :=

Line 41: ,pay_payroll_actions ppa

37: , ppa.effective_date effective_date
38: ,opm.org_payment_method_name personal_payment_method_name
39: ,opm.currency_code currency_code
40: FROM pay_pre_payments ppp
41: ,pay_payroll_actions ppa
42: ,pay_assignment_actions paa
43: ,pay_org_payment_methods_f opm
44: ,pay_personal_payment_methods_f ppm
45: ,pay_external_accounts pea

Line 89: ,pay_payroll_actions ppa

85: ,ppf.full_name payee_name
86: ,pea.segment3 personal_bank_account_number
87: ,ppp.value payment_amount
88: FROM pay_pre_payments ppp
89: ,pay_payroll_actions ppa
90: ,pay_assignment_actions paa
91: ,pay_org_payment_methods_f opm
92: ,pay_personal_payment_methods_f ppm
93: ,pay_external_accounts pea