APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_ACCOUNT_OWNERS

Line 1348: IBY_ACCOUNT_OWNERS owners,

1344:
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

Line 2335: IBY_ACCOUNT_OWNERS owners,

2331:
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

Line 3126: FROM IBY_ACCOUNT_OWNERS

3122: WHERE b.EXT_BANK_ACCOUNT_ID = p_bankacct_id;
3123:
3124: CURSOR c_acct_owner IS
3125: SELECT ACCOUNT_OWNER_PARTY_ID
3126: FROM IBY_ACCOUNT_OWNERS
3127: WHERE EXT_BANK_ACCOUNT_ID = p_bankacct_id
3128: AND PRIMARY_FLAG = 'Y';
3129:
3130: l_bank_account_rec c_bank_account%ROWTYPE;

Line 4158: FROM IBY_ACCOUNT_OWNERS

4154: -- more than once.
4155: CURSOR uniq_check(p_party_id NUMBER, bank_account_id NUMBER)
4156: IS
4157: SELECT COUNT(*)
4158: FROM IBY_ACCOUNT_OWNERS
4159: WHERE ACCOUNT_OWNER_PARTY_ID = p_party_id
4160: AND EXT_BANK_ACCOUNT_ID = bank_account_id;
4161:
4162: -- No of Active account owners

Line 4166: FROM IBY_ACCOUNT_OWNERS

4162: -- No of Active account owners
4163: CURSOR active_owners(bank_account_id NUMBER)
4164: IS
4165: SELECT COUNT(*)
4166: FROM IBY_ACCOUNT_OWNERS
4167: WHERE EXT_BANK_ACCOUNT_ID = bank_account_id;
4168: -- AND (end_date IS NULL OR end_date > sysdate);
4169:
4170: BEGIN

Line 4221: -- Insert Row in IBY_ACCOUNT_OWNERS

4217: IF (l_count <= 0) THEN
4218: l_primary_flag := 'Y';
4219: END IF;
4220:
4221: -- Insert Row in IBY_ACCOUNT_OWNERS
4222: INSERT INTO IBY_ACCOUNT_OWNERS
4223: (
4224: ACCOUNT_OWNER_ID,
4225: EXT_BANK_ACCOUNT_ID,

Line 4222: INSERT INTO IBY_ACCOUNT_OWNERS

4218: l_primary_flag := 'Y';
4219: END IF;
4220:
4221: -- Insert Row in IBY_ACCOUNT_OWNERS
4222: INSERT INTO IBY_ACCOUNT_OWNERS
4223: (
4224: ACCOUNT_OWNER_ID,
4225: EXT_BANK_ACCOUNT_ID,
4226: ACCOUNT_OWNER_PARTY_ID,

Line 4238: IBY_ACCOUNT_OWNERS_S.NEXTVAL,

4234: OBJECT_VERSION_NUMBER
4235: )
4236: VALUES
4237: (
4238: IBY_ACCOUNT_OWNERS_S.NEXTVAL,
4239: p_bank_account_id,
4240: p_acct_owner_party_id,
4241: NULL,
4242: l_primary_flag,

Line 4360: UPDATE IBY_ACCOUNT_OWNERS

4356: check_mandatory('IBY_END_DATE',p_end_date);
4357: check_mandatory('IBY_OBJ_VER_NUM',p_object_version_number);
4358:
4359: -- Set End Date to joint owners table
4360: UPDATE IBY_ACCOUNT_OWNERS
4361: SET END_DATE = p_end_date,
4362: OBJECT_VERSION_NUMBER = p_object_version_number + 1
4363: WHERE ACCOUNT_OWNER_ID = p_acct_owner_id
4364: AND OBJECT_VERSION_NUMBER = p_object_version_number

Line 4369: print_debuginfo('Warning : No Matching Rows found in IBY_ACCOUNT_OWNERS');

4365: RETURNING OBJECT_VERSION_NUMBER INTO p_object_version_number;
4366:
4367: IF (SQL%NOTFOUND) THEN
4368: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4369: print_debuginfo('Warning : No Matching Rows found in IBY_ACCOUNT_OWNERS');
4370: END IF;
4371: END IF;
4372:
4373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4448: FROM IBY_ACCOUNT_OWNERS

4444: -- Pick up Current Primary Account for the Bank Account Id
4445: CURSOR c_account_owner(bank_account_id NUMBER)
4446: IS
4447: SELECT account_owner_id
4448: FROM IBY_ACCOUNT_OWNERS
4449: WHERE EXT_BANK_ACCOUNT_ID = bank_account_id
4450: AND primary_flag = 'Y';
4451:
4452: BEGIN

Line 4484: UPDATE IBY_ACCOUNT_OWNERS

4480: check_mandatory('IBY_ACCTOWNER_PARTYID_FIELD',p_acct_owner_party_id);
4481:
4482: FOR l_account_owner_id IN c_account_owner(p_bank_acct_id)
4483: LOOP
4484: UPDATE IBY_ACCOUNT_OWNERS
4485: SET PRIMARY_FLAG = 'N'
4486: WHERE EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
4487: END LOOP;
4488:

Line 4489: UPDATE IBY_ACCOUNT_OWNERS

4485: SET PRIMARY_FLAG = 'N'
4486: WHERE EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
4487: END LOOP;
4488:
4489: UPDATE IBY_ACCOUNT_OWNERS
4490: SET PRIMARY_FLAG = 'Y'
4491: WHERE ACCOUNT_OWNER_PARTY_ID = p_acct_owner_party_id
4492: AND EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
4493:

Line 4617: FROM IBY_ACCOUNT_OWNERS

4613:
4614: BEGIN
4615: SELECT account_owner_id
4616: INTO l_owner_id
4617: FROM IBY_ACCOUNT_OWNERS
4618: WHERE EXT_BANK_ACCOUNT_ID = p_bank_acct_id
4619: AND account_owner_party_id = p_acct_owner_party_id
4620: AND nvl(end_date, sysdate+1) > sysdate;
4621: