APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 1335: l_org_id iby_external_payees_all.org_id%TYPE;

1331: l_supplier_number ap_suppliers.segment1%TYPE;
1332:
1333: l_error_msg VARCHAR2(500);
1334: l_ret_stat VARCHAR2(1);
1335: l_org_id iby_external_payees_all.org_id%TYPE;
1336: l_org_name hr_operating_units.name%TYPE;
1337: -- picks up branch number
1338: CURSOR c_branch (p_branch_id NUMBER) IS
1339: SELECT bank_or_branch_number

Line 1349: iby_external_payees_all payees

1345: CURSOR c_supplier(p_acct_id NUMBER) IS
1346: SELECT owners.account_owner_party_id
1347: FROM iby_pmt_instr_uses_all instrument,
1348: IBY_ACCOUNT_OWNERS owners,
1349: iby_external_payees_all payees
1350: WHERE
1351: owners.primary_flag = 'Y' AND
1352: owners.ext_bank_account_id = p_acct_id AND
1353: owners.ext_bank_account_id = instrument.instrument_id AND

Line 2045: -- from iby_external_payees_all

2041: IF(p_supplier_site_id IS NOT NULL) THEN
2042: BEGIN
2043: --select party_site_id, org_id, org_type
2044: -- INTO l_party_site_id, l_org_id, l_org_type
2045: -- from iby_external_payees_all
2046: --where payee_party_id=p_ext_bank_acct_rec.acct_owner_party_id AND
2047: -- PAYMENT_FUNCTION='PAYABLES_DISB' AND
2048: -- SUPPLIER_SITE_ID =p_supplier_site_id;
2049: select org_id, vendor_site_id

Line 2101: from iby_external_payees_all

2097: IF(p_party_site_id IS NOT NULL AND p_org_id IS NOT NULL) THEN
2098: /*BEGIN
2099: select org_type
2100: INTO l_org_type
2101: from iby_external_payees_all
2102: where payee_party_id=p_ext_bank_acct_rec.acct_owner_party_id AND
2103: PAYMENT_FUNCTION='PAYABLES_DISB' AND
2104: PARTY_SITE_ID =p_party_site_id AND
2105: ORG_ID = p_org_id AND

Line 2283: l_org_id iby_external_payees_all.org_id%TYPE;

2279: l_supplier_number ap_suppliers.segment1%TYPE;
2280:
2281: l_error_msg VARCHAR2(500);
2282: l_ret_stat VARCHAR2(1);
2283: l_org_id iby_external_payees_all.org_id%TYPE;
2284: l_org_name hr_operating_units.name%TYPE;
2285: -- Get Object Version Number
2286: CURSOR c_ovn (p_acct_id NUMBER) IS
2287: SELECT object_version_number,

Line 2336: iby_external_payees_all payees

2332: CURSOR c_supplier(p_acct_id NUMBER) IS
2333: SELECT owners.account_owner_party_id
2334: FROM iby_pmt_instr_uses_all instrument,
2335: IBY_ACCOUNT_OWNERS owners,
2336: iby_external_payees_all payees
2337: WHERE
2338: owners.primary_flag = 'Y' AND
2339: owners.ext_bank_account_id = p_acct_id AND
2340: owners.ext_bank_account_id = instrument.instrument_id AND

Line 5571: SELECT org_id INTO l_org_id FROM iby_external_payees_all

5567: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5568: print_debuginfo('ENTER ' || l_module_name);
5569: END IF;
5570: BEGIN
5571: SELECT org_id INTO l_org_id FROM iby_external_payees_all
5572: WHERE org_id IS NOT NULL AND org_type IS NOT null
5573: AND
5574: ext_payee_id IN(
5575: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE

Line 5585: SELECT org_id INTO l_org_id FROM iby_external_payees_all

5581: AND ROWNUM=1;
5582: EXCEPTION
5583: WHEN no_data_found THEN
5584: BEGIN
5585: SELECT org_id INTO l_org_id FROM iby_external_payees_all
5586: WHERE org_id IS NOT NULL AND org_type IS NOT null
5587: AND
5588: ext_payee_id IN(
5589: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE