APPS.GR_REG_PRINT_DOC dependencies on HZ_PARTY_SITES

Line 62: FROM hz_party_sites

58: -- from the shipment based upon the ship_to_location_id.
59: /* Used to retrieve the party id that will actually recieve the document */
60: CURSOR c_get_recipient_id (p_ship_to_location_id NUMBER) IS
61: SELECT party_id
62: FROM hz_party_sites
63: WHERE party_site_id = p_ship_to_location_id;
64:
65: /* M.Grosser 12-Apr-2005 Added retrieval of document_id for 3rd Party Integration project.
66: */

Line 799: FROM hz_party_sites

795:
796:
797: CURSOR c_get_recipient_details IS
798: SELECT party_id, party_site_id
799: FROM hz_party_sites
800: WHERE party_site_number = p_recipient_site;
801:
802: Cursor C_get_organization_code(l_orgn_id number) IS
803: SELECT ORGANIZATION_CODE from mtl_parameters