APPS.PAY_ZA_BANK_DDF_UPD dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 43: from pay_personal_payment_methods_f ppymf

39: cursor csr_ppm_category
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')

Line 93: update pay_personal_payment_methods_f

89: ,P_EFFECTIVE_START_DATE => l_effective_start_date
90: ,P_EFFECTIVE_END_DATE => l_effective_end_date
91: );
92: */
93: update pay_personal_payment_methods_f
94: set ppm_information_category = l_legislation_code||'_'||upper(rec_ppm_category.payment_type_name)
95: where personal_payment_method_id = rec_ppm_category.personal_payment_method_id;
96:
97: hr_utility.set_location('Updated PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);