APPS.AHL_OSP_SHIPMENT_PUB dependencies on CSI_I_PARTIES

Line 5015: SELECT INSTANCE_PARTY_ID, PARTY_ID from csi_i_parties

5011: OE.HEADER_ID = OEL.HEADER_ID AND
5012: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
5013:
5014: CURSOR get_owner_ip_id(p_instance_id IN NUMBER) IS
5015: SELECT INSTANCE_PARTY_ID, PARTY_ID from csi_i_parties
5016: WHERE INSTANCE_ID = p_instance_id AND
5017: RELATIONSHIP_TYPE_CODE = 'OWNER' AND
5018: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
5019: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;

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

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