DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on ARP_ADDR_PKG

Line 1231: 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,

1227: u.instrument_id bank_account_id,
1228: 1 bank_branch_id,
1229: nvl(c.chname, hzcc.party_name) account_holder,
1230: NULL cvv_code,
1231: 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,
1232: c.card_issuer_code card_code,
1233: psu.party_site_id,
1234: u.instrument_payment_use_id,
1235: NULL bank_party_id,

Line 1336: 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,

1332: u.instrument_id bank_account_id,
1333: 1 bank_branch_id,
1334: NVL(c.chname,hzcc.party_name) account_holder,
1335: NULL cvv_code,
1336: 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,
1337: c.card_issuer_code card_code,
1338: psu.party_site_id,
1339: u.instrument_payment_use_id instr_assignment_id,
1340: NULL bank_party_id,