DBA Data[Home] [Help]

APPS.PA_PWP_SUMM_PKG dependencies on ARP_ADDR_PKG

Line 469: (SELECT ARP_ADDR_PKG.FORMAT_ADDRESS ( ba_loc.ADDRESS_STYLE ,ba_loc.ADDRESS1 ,ba_loc.ADDRESS2

465: ( bill_to_address,
466: ship_to_address
467: )
468: =
469: (SELECT ARP_ADDR_PKG.FORMAT_ADDRESS ( ba_loc.ADDRESS_STYLE ,ba_loc.ADDRESS1 ,ba_loc.ADDRESS2
470: ,ba_loc.ADDRESS3 ,ba_loc.ADDRESS4 ,ba_loc.CITY ,ba_loc.COUNTY ,ba_loc.STATE ,
471: ba_loc.PROVINCE ,ba_loc.POSTAL_CODE ,TERR_B.TERRITORY_SHORT_NAME )
472: BILL_CONCATENATED_ADDRESS,
473: ARP_ADDR_PKG.FORMAT_ADDRESS ( sa_loc.ADDRESS_STYLE ,sa_loc.ADDRESS1 ,sa_loc.ADDRESS2

Line 473: ARP_ADDR_PKG.FORMAT_ADDRESS ( sa_loc.ADDRESS_STYLE ,sa_loc.ADDRESS1 ,sa_loc.ADDRESS2

469: (SELECT ARP_ADDR_PKG.FORMAT_ADDRESS ( ba_loc.ADDRESS_STYLE ,ba_loc.ADDRESS1 ,ba_loc.ADDRESS2
470: ,ba_loc.ADDRESS3 ,ba_loc.ADDRESS4 ,ba_loc.CITY ,ba_loc.COUNTY ,ba_loc.STATE ,
471: ba_loc.PROVINCE ,ba_loc.POSTAL_CODE ,TERR_B.TERRITORY_SHORT_NAME )
472: BILL_CONCATENATED_ADDRESS,
473: ARP_ADDR_PKG.FORMAT_ADDRESS ( sa_loc.ADDRESS_STYLE ,sa_loc.ADDRESS1 ,sa_loc.ADDRESS2
474: ,sa_loc.ADDRESS3 ,sa_loc.ADDRESS4 ,sa_loc.CITY ,sa_loc.COUNTY ,sa_loc.STATE ,
475: sa_loc.PROVINCE ,sa_loc.POSTAL_CODE ,TERR_S.TERRITORY_SHORT_NAME )
476: SHIP_CONCATENATED_ADDRESS
477: FROM FND_TERRITORIES_TL TERR_B ,