DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on IBY_ACCOUNT_OWNERS

Line 1278: from iby_ext_bank_accounts act, iby_account_owners ow

1274: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
1275:
1276: cursor l_cur_act_cur is
1277: select act.object_version_number, ow.account_owner_party_id
1278: from iby_ext_bank_accounts act, iby_account_owners ow
1279: where ow.ext_bank_account_id = act.ext_bank_account_id
1280: and act.ext_bank_account_id = l_ext_bank_account_id
1281: and ow.primary_flag = 'Y'
1282: and NVL(ow.end_date,SYSDATE+10)>SYSDATE

Line 1808: select count(*) from iby_ext_bank_accounts act, iby_account_owners o, pos_supplier_mappings pmap

1804: AND ((pos.account_request_id <> p_account_request_id and p_account_request_id is not null and
1805: pos.account_request_id is not null) OR (p_account_request_id is null));
1806:
1807: cursor dup_cur_act_cur is
1808: select count(*) from iby_ext_bank_accounts act, iby_account_owners o, pos_supplier_mappings pmap
1809: where o.ext_bank_account_id = act.ext_bank_account_id
1810: and (
1811: (act.currency_code = p_currency_code
1812: and act.currency_code is not null and p_currency_code is not null) OR