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

Line 1073: -- Check if external_account_id exists on pay_external_accounts

1069: and p_effective_date between opm.effective_start_date
1070: and opm.effective_end_date
1071: and pyt.category = 'MT';
1072: --
1073: -- Check if external_account_id exists on pay_external_accounts
1074: --
1075: cursor csr_chk_ext_acct_id is
1076: select null
1077: from pay_external_accounts pea

Line 1077: from pay_external_accounts pea

1073: -- Check if external_account_id exists on pay_external_accounts
1074: --
1075: cursor csr_chk_ext_acct_id is
1076: select null
1077: from pay_external_accounts pea
1078: where pea.external_account_id = p_external_account_id;
1079: --
1080: -- Check that the flex structure for the external account matches
1081: -- the flex structure already defined for the opm.

Line 1085: from pay_external_accounts pea1,

1081: -- the flex structure already defined for the opm.
1082: --
1083: cursor chk_org_flex_struct is
1084: select null
1085: from pay_external_accounts pea1,
1086: pay_external_accounts pea2,
1087: pay_org_payment_methods_f opm
1088: where pea1.external_account_id = p_external_account_id
1089: and opm.org_payment_method_id = p_org_payment_method_id

Line 1086: pay_external_accounts pea2,

1082: --
1083: cursor chk_org_flex_struct is
1084: select null
1085: from pay_external_accounts pea1,
1086: pay_external_accounts pea2,
1087: pay_org_payment_methods_f opm
1088: where pea1.external_account_id = p_external_account_id
1089: and opm.org_payment_method_id = p_org_payment_method_id
1090: and opm.external_account_id = pea2.external_account_id