APPS.ARP_EXT_BANK_PKG dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 725: SELECT count(*) INTO l_count FROM iby_fndcpt_payer_assgn_instr_v

721:
722: -- Bug 7346354 - Start
723: IF ( l_bank_account_id IS NOT NULL ) AND ( p_customer_id IS NOT NULL ) THEN
724: -- Check whether the assignment exists already
725: SELECT count(*) INTO l_count FROM iby_fndcpt_payer_assgn_instr_v
726: WHERE cust_account_id = p_customer_id
727: AND bank_acct_num_hash1 = iby_security_pkg.get_hash(p_account_number, 'F')
728: AND bank_acct_num_hash2 = iby_security_pkg.get_hash(p_account_number, 'T')
729: AND branch_number = p_routing_number;

Line 785: x_instr_assign_id OUT NOCOPY iby_fndcpt_payer_assgn_instr_v.INSTR_ASSIGNMENT_ID%TYPE,

781: p_party_id IN NUMBER,
782: p_customer_id IN NUMBER,
783: p_instr_id IN NUMBER,
784: p_assignment_start_date IN DATE,
785: x_instr_assign_id OUT NOCOPY iby_fndcpt_payer_assgn_instr_v.INSTR_ASSIGNMENT_ID%TYPE,
786: x_return_status OUT NOCOPY VARCHAR2) IS
787:
788: l_payer_context_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
789: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;