APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_INSTALL_PARAMETERS

Line 5004: SELECT internal_party_id from csi_install_parameters;

5000: FROM ahl_osp_order_lines
5001: WHERE oe_ship_line_id = p_oe_line_id;
5002:
5003: CURSOR get_internal_party_csr IS
5004: SELECT internal_party_id from csi_install_parameters;
5005:
5006: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5007: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5008: OE_ORDER_HEADERS_ALL OE,

Line 5777: SELECT internal_party_id from csi_install_parameters;

5773: AND csii.inventory_item_id(+) = ospl.inventory_item_id
5774: AND csii.serial_number(+) = ospl.serial_number;
5775:
5776: CURSOR get_internal_party_csr IS
5777: SELECT internal_party_id from csi_install_parameters;
5778:
5779: CURSOR get_owner_ip_id(p_instance_id IN NUMBER) IS
5780: SELECT INSTANCE_PARTY_ID, PARTY_ID, OBJECT_VERSION_NUMBER from csi_i_parties where
5781: INSTANCE_ID = p_instance_id AND