DBA Data[Home] [Help]

APPS.PAY_IN_EFT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 14: g_org_pay_meth_param CONSTANT pay_org_payment_methods_f.org_payment_method_id%TYPE :=

10: g_cons_set_param CONSTANT pay_consolidation_sets.consolidation_set_id%TYPE :=
11: pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_PARAM');
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:

Line 47: pay_org_payment_methods_f popm

43: , oea.segment3 org_bank_name
44: , oea.segment4 org_bank_branch
45: , oea.segment1 bank_acc_num
46: FROM
47: pay_org_payment_methods_f popm
48: , pay_external_accounts pea
49: , pay_personal_payment_methods_f pppm
50: , pay_external_accounts oea
51: , pay_pre_payments ppp

Line 123: FROM pay_org_payment_methods_f popm

119: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
120: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
121: , pea.segment1 emp_acc_num
122: , NVL(ppp.value,0) payment_amt
123: FROM pay_org_payment_methods_f popm
124: , pay_external_accounts oea
125: , pay_personal_payment_methods_f pppm
126: , pay_external_accounts pea
127: , pay_pre_payments ppp