DBA Data[Home] [Help]

APPS.PAY_NZ_EFT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 60: pay_org_payment_methods_f popm

56: ,substr(to_char(SUM(nvl(ppp.VALUE,0) * 100)),1,11)
57: ,'TRANSFER_HEAD_FLAG=P'
58: ,'Not_Printed'
59: from
60: pay_org_payment_methods_f popm
61: , pay_external_accounts oea
62: , pay_personal_payment_methods_f pppm
63: , pay_external_accounts pea
64: , pay_pre_payments ppp

Line 138: pay_org_payment_methods_f popm

134: , 'THIS_PARTY_NAME=P'
135: , substr
136: (replace(p.first_name,',') ||' '||replace(p.last_name,','), 1, 20) -- this_party_name ie payee_name
137: from
138: pay_org_payment_methods_f popm
139: , pay_external_accounts oea
140: , pay_personal_payment_methods_f pppm
141: , pay_external_accounts pea
142: , pay_pre_payments ppp