APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 237: from pay_personal_payment_methods_f ppm

233: as
234:
235: CURSOR csr_get_tag_name (p_per_meth_id number,p_eff_date date ,p_tag_name varchar2) IS
236: select fcu.end_user_column_name
237: from pay_personal_payment_methods_f ppm
238: ,fnd_descr_flex_column_usages fcu
239: where ppm.personal_payment_method_id=p_per_meth_id
240: and fcu.descriptive_flex_context_code=ppm.ppm_information_category
241: and fcu.application_column_name =p_tag_name

Line 418: FROM pay_personal_payment_methods_f pppm

414: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
415: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
416: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code),
417: pppm.payee_id,pppm.payee_type
418: FROM pay_personal_payment_methods_f pppm
419: , pay_external_accounts pea
420: WHERE pppm.personal_payment_method_id = p_per_pay_method
421: AND pppm.external_account_id = pea.external_account_id
422: AND p_effective_date between pppm.EFFECTIVE_START_DATE

Line 602: FROM pay_personal_payment_methods_f

598: ppm_information11,ppm_information12,ppm_information13,ppm_information14,ppm_information15,
599: ppm_information16,ppm_information17,ppm_information18,ppm_information19,ppm_information20,
600: ppm_information21,ppm_information22,ppm_information23,ppm_information24,ppm_information25,
601: ppm_information26,ppm_information27,ppm_information28,ppm_information29,ppm_information30
602: FROM pay_personal_payment_methods_f
603: WHERE personal_payment_method_id = p_ppm_id
604: and p_effective_date between effective_start_date and effective_end_date;
605:
606: CURSOR csr_opm_info (p_opm_id NUMBER,

Line 617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;

613: FROM pay_org_payment_methods_f
614: WHERE org_payment_method_id = p_opm_id
615: and p_effective_date between effective_start_date and effective_end_date;
616: --
617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;