APPS.AR_IREC_PAYMENTS dependencies on ARP_ADDR_PKG

Line 1305: arp_addr_pkg.format_address(loc.address_style, loc.address1, loc.address2, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, loc.postal_code, terr.territory_short_name) conc_address,

1301: c.INSTRUMENT_ID bank_account_id,
1302: 1 bank_branch_id,
1303: nvl(c.CARD_HOLDER_NAME, hzcc.party_name) account_holder,
1304: NULL cvv_code,
1305: arp_addr_pkg.format_address(loc.address_style, loc.address1, loc.address2, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, loc.postal_code, terr.territory_short_name) conc_address,
1306: c.CARD_ISSUER_CODE card_code,
1307: psu.party_site_id,
1308: c.INSTR_ASSIGNMENT_ID,
1309: NULL bank_party_id,

Line 1408: arp_addr_pkg.format_address(loc.address_style, loc.address1, loc.address2, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, loc.postal_code, terr.territory_short_name) conc_address,

1404: u.instrument_id bank_account_id,
1405: 1 bank_branch_id,
1406: NVL(c.chname,hzcc.party_name) account_holder,
1407: NULL cvv_code,
1408: arp_addr_pkg.format_address(loc.address_style, loc.address1, loc.address2, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, loc.postal_code, terr.territory_short_name) conc_address,
1409: c.card_issuer_code card_code,
1410: psu.party_site_id,
1411: u.instrument_payment_use_id instr_assignment_id,
1412: NULL bank_party_id,