APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_I_PARTIES

Line 4970: SELECT INSTANCE_PARTY_ID, PARTY_ID from csi_i_parties

4966: OE.HEADER_ID = OEL.HEADER_ID AND
4967: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
4968:
4969: CURSOR get_owner_ip_id(p_instance_id IN NUMBER) IS
4970: SELECT INSTANCE_PARTY_ID, PARTY_ID from csi_i_parties
4971: WHERE INSTANCE_ID = p_instance_id AND
4972: RELATIONSHIP_TYPE_CODE = 'OWNER' AND
4973: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
4974: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;

Line 5735: SELECT INSTANCE_PARTY_ID, PARTY_ID, OBJECT_VERSION_NUMBER from csi_i_parties where

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
5737: relationship_type_code = 'OWNER' AND
5738: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
5739: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;