DBA Data[Home] [Help]

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 4341: FROM csi_i_parties

4337: SELECT instance_party_id,
4338: object_version_number
4339: INTO l_instance_party_id,
4340: l_pty_object_ver_num
4341: FROM csi_i_parties
4342: WHERE instance_id = p_instance_id;
4343:
4344: l_u_party_tbl(1).instance_party_id := l_instance_party_id;
4345: l_u_party_tbl(1).instance_id := p_instance_id;

Line 6232: FROM CSI_I_PARTIES

6228:
6229: BEGIN
6230: SELECT object_version_number
6231: INTO l_upd_party_tbl(1).object_version_number
6232: FROM CSI_I_PARTIES
6233: WHERE instance_party_id = l_upd_party_tbl(1).instance_party_id;
6234: END;
6235: /* End Of fix for Bug 2728984 */
6236: END IF;