APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_INSTALL_PARAMETERS

Line 4959: SELECT internal_party_id from csi_install_parameters;

4955: FROM ahl_osp_order_lines
4956: WHERE oe_ship_line_id = p_oe_line_id;
4957:
4958: CURSOR get_internal_party_csr IS
4959: SELECT internal_party_id from csi_install_parameters;
4960:
4961: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
4962: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
4963: OE_ORDER_HEADERS_ALL OE,

Line 5732: SELECT internal_party_id from csi_install_parameters;

5728: AND csii.inventory_item_id(+) = ospl.inventory_item_id
5729: AND csii.serial_number(+) = ospl.serial_number;
5730:
5731: CURSOR get_internal_party_csr IS
5732: SELECT internal_party_id from csi_install_parameters;
5733:
5734: CURSOR get_owner_ip_id(p_instance_id IN NUMBER) IS
5735: SELECT INSTANCE_PARTY_ID, PARTY_ID, OBJECT_VERSION_NUMBER from csi_i_parties where
5736: INSTANCE_ID = p_instance_id AND