APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_I_PARTIES

Line 209: FROM csi_i_parties

205: END IF;
206:
207: SELECT instance_party_id
208: INTO l_instance_party_id
209: FROM csi_i_parties
210: WHERE instance_id = l_ship_tbl(s_ind).instance_id
211: AND relationship_type_code = 'OWNER';
212:
213: BEGIN

Line 4262: FROM csi_i_parties

4258: SELECT instance_party_id,
4259: object_version_number
4260: INTO l_instance_party_id,
4261: l_pty_object_ver_num
4262: FROM csi_i_parties
4263: WHERE instance_id = p_instance_id;
4264:
4265: l_u_party_tbl(1).instance_party_id := l_instance_party_id;
4266: l_u_party_tbl(1).instance_id := p_instance_id;

Line 5972: FROM CSI_I_PARTIES

5968:
5969: BEGIN
5970: SELECT object_version_number
5971: INTO l_upd_party_tbl(1).object_version_number
5972: FROM CSI_I_PARTIES
5973: WHERE instance_party_id = l_upd_party_tbl(1).instance_party_id;
5974: END;
5975: /* End Of fix for Bug 2728984 */
5976: END IF;