APPS.GMF_AR_GET_CUST_CURRENCY dependencies on AP_BANK_ACCOUNT_USES_ALL

Line 9: from AP_BANK_ACCOUNT_USES_ALL BAU,

5: siteuseid number) is
6: select BAU.CUSTOMER_ID,
7: BAU.CUSTOMER_SITE_USE_ID,
8: BAC.CURRENCY_CODE
9: from AP_BANK_ACCOUNT_USES_ALL BAU,
10: AP_BANK_ACCOUNTS_ALL BAC
11: where ((BAU.customer_id = nvl(custid, BAU.customer_id)
12: and BAU.customer_site_use_id =
13: nvl(siteuseid, BAU.customer_site_use_id))

Line 43: from AP_BANK_ACCOUNT_USES_ALL BAU

39: no_of_cust_accounts := 1;
40:
41: select count(*)
42: into no_of_site_accounts
43: from AP_BANK_ACCOUNT_USES_ALL BAU
44: where BAU.customer_id = nvl(cust_id, BAU.customer_id)
45: and BAU.customer_site_use_id =
46: nvl(site_use_id, BAU.customer_site_use_id)
47: and upper(bau.primary_flag) like 'Y%';

Line 56: from AP_BANK_ACCOUNT_USES_ALL BAU

52:
53: if no_of_site_accounts = 0 then
54: select count(*)
55: into no_of_cust_accounts
56: from AP_BANK_ACCOUNT_USES_ALL BAU
57: where BAU.customer_id = nvl(cust_id, BAU.customer_id)
58: and BAU.customer_site_use_id IS NULL
59: and upper(bau.primary_flag) like 'Y%'
60: and nvl(bau.org_id,0) = nvl(porg_id, nvl(bau.org_id,0));