APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_ACCOUNT_OWNERS

Line 1214: IBY_ACCOUNT_OWNERS owners,

1210:
1211: CURSOR c_supplier(p_acct_id NUMBER) IS
1212: SELECT owners.account_owner_party_id
1213: FROM iby_pmt_instr_uses_all instrument,
1214: IBY_ACCOUNT_OWNERS owners,
1215: iby_external_payees_all payees
1216: WHERE
1217: owners.primary_flag = 'Y' AND
1218: owners.ext_bank_account_id = p_acct_id AND

Line 1990: IBY_ACCOUNT_OWNERS owners,

1986:
1987: CURSOR c_supplier(p_acct_id NUMBER) IS
1988: SELECT owners.account_owner_party_id
1989: FROM iby_pmt_instr_uses_all instrument,
1990: IBY_ACCOUNT_OWNERS owners,
1991: iby_external_payees_all payees
1992: WHERE
1993: owners.primary_flag = 'Y' AND
1994: owners.ext_bank_account_id = p_acct_id AND

Line 2559: FROM IBY_ACCOUNT_OWNERS

2555: WHERE b.EXT_BANK_ACCOUNT_ID = p_bankacct_id;
2556:
2557: CURSOR c_acct_owner IS
2558: SELECT ACCOUNT_OWNER_PARTY_ID
2559: FROM IBY_ACCOUNT_OWNERS
2560: WHERE EXT_BANK_ACCOUNT_ID = p_bankacct_id
2561: AND PRIMARY_FLAG = 'Y';
2562:
2563: l_bank_account_rec c_bank_account%ROWTYPE;

Line 3508: FROM IBY_ACCOUNT_OWNERS

3504: -- more than once.
3505: CURSOR uniq_check(p_party_id NUMBER, bank_account_id NUMBER)
3506: IS
3507: SELECT COUNT(*)
3508: FROM IBY_ACCOUNT_OWNERS
3509: WHERE ACCOUNT_OWNER_PARTY_ID = p_party_id
3510: AND EXT_BANK_ACCOUNT_ID = bank_account_id;
3511:
3512: BEGIN

Line 3549: -- Insert Row in IBY_ACCOUNT_OWNERS

3545: fnd_msg_pub.add;
3546: RETURN;
3547: END IF;
3548:
3549: -- Insert Row in IBY_ACCOUNT_OWNERS
3550: INSERT INTO IBY_ACCOUNT_OWNERS
3551: (
3552: ACCOUNT_OWNER_ID,
3553: EXT_BANK_ACCOUNT_ID,

Line 3550: INSERT INTO IBY_ACCOUNT_OWNERS

3546: RETURN;
3547: END IF;
3548:
3549: -- Insert Row in IBY_ACCOUNT_OWNERS
3550: INSERT INTO IBY_ACCOUNT_OWNERS
3551: (
3552: ACCOUNT_OWNER_ID,
3553: EXT_BANK_ACCOUNT_ID,
3554: ACCOUNT_OWNER_PARTY_ID,

Line 3566: IBY_ACCOUNT_OWNERS_S.NEXTVAL,

3562: OBJECT_VERSION_NUMBER
3563: )
3564: VALUES
3565: (
3566: IBY_ACCOUNT_OWNERS_S.NEXTVAL,
3567: p_bank_account_id,
3568: p_acct_owner_party_id,
3569: NULL,
3570: 'N',

Line 3676: UPDATE IBY_ACCOUNT_OWNERS

3672: check_mandatory('End Date',p_end_date);
3673: check_mandatory('Object Version Number',p_object_version_number);
3674:
3675: -- Set End Date to joint owners table
3676: UPDATE IBY_ACCOUNT_OWNERS
3677: SET END_DATE = p_end_date,
3678: OBJECT_VERSION_NUMBER = p_object_version_number + 1
3679: WHERE ACCOUNT_OWNER_ID = p_acct_owner_id
3680: AND OBJECT_VERSION_NUMBER = p_object_version_number

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

3680: AND OBJECT_VERSION_NUMBER = p_object_version_number
3681: RETURNING OBJECT_VERSION_NUMBER INTO p_object_version_number;
3682:
3683: IF (SQL%NOTFOUND) THEN
3684: print_debuginfo('Warning : No Matching Rows found in IBY_ACCOUNT_OWNERS');
3685: END IF;
3686:
3687: print_debuginfo('Updated Object Version Number : ' || p_object_version_number);
3688:

Line 3758: FROM IBY_ACCOUNT_OWNERS

3754: -- Pick up Current Primary Account for the Bank Account Id
3755: CURSOR c_account_owner(bank_account_id NUMBER)
3756: IS
3757: SELECT account_owner_id
3758: FROM IBY_ACCOUNT_OWNERS
3759: WHERE EXT_BANK_ACCOUNT_ID = bank_account_id
3760: AND primary_flag = 'Y';
3761:
3762: BEGIN

Line 3792: UPDATE IBY_ACCOUNT_OWNERS

3788: check_mandatory('Account Owner Party Id',p_acct_owner_party_id);
3789:
3790: FOR l_account_owner_id IN c_account_owner(p_bank_acct_id)
3791: LOOP
3792: UPDATE IBY_ACCOUNT_OWNERS
3793: SET PRIMARY_FLAG = 'N'
3794: WHERE EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
3795: END LOOP;
3796:

Line 3797: UPDATE IBY_ACCOUNT_OWNERS

3793: SET PRIMARY_FLAG = 'N'
3794: WHERE EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
3795: END LOOP;
3796:
3797: UPDATE IBY_ACCOUNT_OWNERS
3798: SET PRIMARY_FLAG = 'Y'
3799: WHERE ACCOUNT_OWNER_PARTY_ID = p_acct_owner_party_id
3800: AND EXT_BANK_ACCOUNT_ID = p_bank_acct_id;
3801: