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.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCT_USES_ALL

Line 7389: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7385:
7386: -- IS AP ACCOUNT?
7387: Select count(*)
7388: into x_ap_count
7389: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7390: where AP_USE_ENABLE_FLAG = 'Y'
7391: and sysdate <= nvl(end_date,sysdate)
7392: and BANK_ACCOUNT_ID = x_bank_account_id
7393: and BAU.ORG_ID = OU.ORGANIZATION_ID

Line 7406: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7402:
7403: -- IS AR ACCOUNT?
7404: Select count(*)
7405: into x_ar_count
7406: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7407: where AR_USE_ENABLE_FLAG = 'Y'
7408: and sysdate <= nvl(end_date,sysdate)
7409: and BANK_ACCOUNT_ID = x_bank_account_id
7410: and BAU.ORG_ID = OU.ORGANIZATION_ID

Line 7422: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7418:
7419: -- IS xtr ACCOUNT?
7420: Select count(*)
7421: into x_xtr_count
7422: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7423: where XTR_USE_ENABLE_FLAG = 'Y'
7424: and sysdate <= nvl(end_date,sysdate)
7425: and BANK_ACCOUNT_ID = x_bank_account_id
7426: and BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID --BUG 5122576

Line 7438: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7434:
7435: -- IS pay ACCOUNT?
7436: Select count(*)
7437: into x_pay_count
7438: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7439: where PAY_USE_ENABLE_FLAG = 'Y'
7440: and sysdate <= nvl(end_date,sysdate)
7441: and BANK_ACCOUNT_ID = x_bank_account_id
7442: and BAU.ORG_ID = OU.ORGANIZATION_ID

Line 10056: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

10052: IF (csh_statement_complete_flag = 'N') THEN
10053:
10054: /* Select count(*)
10055: into x_pay_count
10056: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
10057: where bau.PAY_USE_ENABLE_FLAG = 'Y'
10058: and sysdate <= nvl(end_date,sysdate)
10059: and BANK_ACCOUNT_ID = CE_AUTO_BANK_MATCH.csh_bank_account_id
10060: --and BAU.bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id