APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 138: (ci_instrid IN iby_ext_bank_accounts.ext_bank_account_id%TYPE)

134: FROM iby_creditcard
135: WHERE (instrid = ci_instrid);
136:
137: CURSOR c_bankaccount
138: (ci_instrid IN iby_ext_bank_accounts.ext_bank_account_id%TYPE)
139: IS
140: SELECT COUNT(ext_bank_account_id)
141: FROM iby_ext_bank_accounts
142: WHERE (ext_bank_account_id = ci_instrid);

Line 141: FROM iby_ext_bank_accounts

137: CURSOR c_bankaccount
138: (ci_instrid IN iby_ext_bank_accounts.ext_bank_account_id%TYPE)
139: IS
140: SELECT COUNT(ext_bank_account_id)
141: FROM iby_ext_bank_accounts
142: WHERE (ext_bank_account_id = ci_instrid);
143:
144: BEGIN
145:

Line 1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.

1796: ) X,
1797: -- [lmallick]: bug# 12570664
1798: -- This API shouln't be returning the assignments that correspond
1799: -- to inactive instruments. Added the necessary filter conditions
1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.
1801: iby_creditcard c,
1802: iby_ext_bank_accounts b
1803: WHERE X.DUP_RANK = 1
1804: AND c.instrid(+) = x.instrument_id

Line 1802: iby_ext_bank_accounts b

1798: -- This API shouln't be returning the assignments that correspond
1799: -- to inactive instruments. Added the necessary filter conditions
1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.
1801: iby_creditcard c,
1802: iby_ext_bank_accounts b
1803: WHERE X.DUP_RANK = 1
1804: AND c.instrid(+) = x.instrument_id
1805: AND b.ext_bank_account_id(+) = x.instrument_id
1806: AND NVL(c.inactive_date, sysdate+10) > sysdate