DBA Data[Home] [Help]

APPS.PAY_ZA_BANK_DDF_UPD dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 44: , pay_org_payment_methods_f popmf

40: is
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

Line 50: from pay_org_payment_methods_f popmf2

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)
50: from pay_org_payment_methods_f popmf2
51: where popmf.org_payment_method_id = popmf2.org_payment_method_id)
52: and ppymf.org_payment_method_id = popmf.org_payment_method_id
53: and ppymf.assignment_id = p_assignment_id
54: and ppymf.ppm_information_category is null