eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENTCARD_PKG dependencies on HZ_LOCATIONS

Line 955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

951: (p_card_id IN iby_paymentcard.instrid%TYPE,
952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

Line 956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

Line 957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

Line 958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

Line 959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,

Line 960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,

Line 961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,

Line 962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,

Line 993: hz_locations l

989: c.card_issuer_code, c.finame,
990: c.single_use_flag, c.information_only_flag, c.card_purpose,
991: c.description, c.active_flag, c.inactive_date
992: FROM iby_paymentcard c, hz_party_site_uses su, hz_party_sites s,
993: hz_locations l
994: WHERE (instrid = ci_instr_id)
995: AND (c.addressid = su.party_site_use_id(+))
996: AND (su.party_site_id = s.party_site_id(+))
997: AND (s.location_id = l.location_id(+));