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_OPM_BUS dependencies on PAY_EXTERNAL_ACCOUNTS

Line 759: -- row on the parent PAY_EXTERNAL_ACCOUNTS table.

755: -- ----------------------------------------------------------------------------
756: --
757: -- Description:
758: -- Check that the external_account_id is not null and that it refers to a
759: -- row on the parent PAY_EXTERNAL_ACCOUNTS table.
760: -- Also cross validate the TERRITORY_CODE with that of Payment Type's.
761: --
762: -- If there is more than one payment methods with the given category
763: -- then it can be null.

Line 801: from pay_external_accounts exa

797: l_dummy number;
798: --
799: cursor csr_ext_acc_id_exists is
800: select null
801: from pay_external_accounts exa
802: where exa.external_account_id = p_external_account_id
803: and exists
804: (select null
805: from pay_payment_types pty

Line 886: -- Check external_account_id exists within PAY_EXTERNAL_ACCOUNTS.

882: or (NOT l_api_updating)) then
883: --
884: hr_utility.set_location(l_proc,20);
885: --
886: -- Check external_account_id exists within PAY_EXTERNAL_ACCOUNTS.
887: -- Also it check the territory_code of the PAY_EXTERNAL_ACCOUNTS.
888: --
889: open csr_ext_acc_id_exists;
890: fetch csr_ext_acc_id_exists into l_dummy;

Line 887: -- Also it check the territory_code of the PAY_EXTERNAL_ACCOUNTS.

883: --
884: hr_utility.set_location(l_proc,20);
885: --
886: -- Check external_account_id exists within PAY_EXTERNAL_ACCOUNTS.
887: -- Also it check the territory_code of the PAY_EXTERNAL_ACCOUNTS.
888: --
889: open csr_ext_acc_id_exists;
890: fetch csr_ext_acc_id_exists into l_dummy;
891: if csr_ext_acc_id_exists%notfound then