eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 217: from pay_org_payment_methods_f opm

213: as
214:
215: CURSOR csr_get_tag_name (p_org_meth_id number,p_eff_date date ,p_tag_name varchar2) IS
216: select fcu.end_user_column_name
217: from pay_org_payment_methods_f opm
218: ,fnd_descr_flex_column_usages fcu
219: where opm.org_payment_method_id=p_org_meth_id
220: and fcu.descriptive_flex_context_code=opm.pmeth_information_category
221: and fcu.application_column_name =p_tag_name

Line 392: FROM pay_org_payment_methods_f popm

388: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
389: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
390: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
391: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
392: FROM pay_org_payment_methods_f popm
393: , pay_external_accounts pea
394: WHERE org_payment_method_id = p_org_payment_method_id
395: AND popm.external_account_id = pea.external_account_id
396: AND p_effective_date between popm.EFFECTIVE_START_DATE

Line 443: FROM pay_org_payment_methods_f popm

439: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
440: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
441: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
442: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
443: FROM pay_org_payment_methods_f popm
444: , pay_external_accounts pea
445: WHERE org_payment_method_id = p_org_pay_method
446: AND popm.external_account_id = pea.external_account_id
447: AND p_effective_date between popm.EFFECTIVE_START_DATE

Line 613: FROM pay_org_payment_methods_f

609: SELECT pmeth_information1 ,pmeth_information2,pmeth_information3,pmeth_information4,pmeth_information5,
610: pmeth_information6,pmeth_information7,pmeth_information8,pmeth_information9,pmeth_information10,
611: pmeth_information11,pmeth_information12,pmeth_information13,pmeth_information14,pmeth_information15,
612: pmeth_information16,pmeth_information17,pmeth_information18,pmeth_information19,pmeth_information20
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;