DBA Data[Home] [Help]

APPS.PAY_ZA_BANK_DDF_UPD dependencies on PAY_PAYMENT_TYPES

Line 45: , pay_payment_types ppt

41: select ppt.payment_type_name, ppymf.personal_payment_method_id,
42: ppymf.object_version_number, ppymf.effective_start_date
43: from pay_personal_payment_methods_f ppymf
44: , pay_org_payment_methods_f popmf
45: , pay_payment_types ppt
46: where ppt.territory_code='ZA'
47: and ppt.payment_type_name in ('Cheque','Credit Transfer','Manual Payment','ACB')
48: and popmf.payment_type_id = ppt.payment_type_id
49: and popmf.effective_end_date = (select max(effective_end_date)