APPS.ARP_PROC_RECEIPTS1 dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 1704: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1700: FROM HZ_CUST_ACCOUNTS
1701: WHERE CUST_ACCOUNT_ID = p_pay_from_customer;
1702:
1703: SELECT COUNT(*) INTO l_no_of_accounts
1704: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1705: WHERE CUST_ACCOUNT_ID = p_pay_from_customer
1706: AND INSTRUMENT_ID = p_customer_bank_account_id;
1707:
1708: IF PG_DEBUG in ('Y', 'C') THEN

Line 1717: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1713: END IF;
1714:
1715: IF l_no_of_accounts = 0 THEN
1716: SELECT COUNT(*) INTO l_no_of_other_accounts
1717: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1718: WHERE NVL(CUST_ACCOUNT_ID, -99) <> p_pay_from_customer
1719: AND INSTRUMENT_ID = p_customer_bank_account_id;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN

Line 1729: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1725: IF l_no_of_other_accounts = 0 THEN
1726: l_bank_assign_flag := TRUE;
1727: ELSE
1728: SELECT COUNT(*) INTO l_no_of_other_party_accounts
1729: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1730: WHERE PARTY_ID <> l_party_id
1731: AND INSTRUMENT_ID = p_customer_bank_account_id;
1732:
1733: IF PG_DEBUG in ('Y', 'C') THEN

Line 1745: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

1741: UPDATE AR_CASH_RECEIPTS SET
1742: CUSTOMER_BANK_ACCOUNT_ID = NULL,
1743: APPLICATION_NOTES = (SELECT DISTINCT 'Removed Bank Account: '||BANK_NAME||'-'||ACCOUNT_NUMBER||
1744: ' from this receipt.'
1745: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1746: WHERE INSTRUMENT_ID = p_customer_bank_account_id)
1747: WHERE CASH_RECEIPT_ID = p_cash_receipt_id;
1748:
1749: END IF;