APPS.AR_IREC_PAYMENTS dependencies on AR_BANK_DIRECTORY

Line 2958: FROM ar_bank_directory

2954:
2955: CURSOR bank_branch_name_cur (l_routing_number VARCHAR2) IS
2956: SELECT decode(bank_name,null,routing_number,bank_name) bank_name,
2957: decode(bank_name,null,routing_number,bank_name) branch_name
2958: FROM ar_bank_directory
2959: WHERE routing_number = l_routing_number;
2960:
2961: CURSOR ce_chk_bank_exists_cur(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
2962: SELECT bank_party_id,branch_party_id, branch_number

Line 2987: l_bank_name ar_bank_directory.bank_name%type;

2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;

Line 2988: l_branch_name ar_bank_directory.bank_name%type;

2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;
2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;