APPS.CSI_INTERFACE_PKG dependencies on CSI_I_PARTIES

Line 3450: FROM csi_i_parties

3446: IF nvl(l_i_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num Then
3447: BEGIN
3448: SELECT instance_party_id
3449: INTO p_txn_party_tbl(l_pc_ind).contact_party_id
3450: FROM csi_i_parties
3451: WHERE instance_id = l_i_rec.instance_id
3452: AND relationship_type_code = p_txn_party_tbl(l_p_ind).relationship_type_code
3453: AND ((active_end_date is null ) OR
3454: (active_end_date > sysdate));

Line 3779: FROM csi_i_parties

3775: SELECT instance_party_id,
3776: object_version_number
3777: INTO px_party_tbl(l_p_ind).instance_party_id,
3778: px_party_tbl(l_p_ind).object_version_number
3779: FROM csi_i_parties
3780: WHERE instance_id = px_instance_rec.instance_id
3781: AND party_source_table = px_party_tbl(l_p_ind).party_source_table
3782: AND relationship_type_code = px_party_tbl(l_p_ind).relationship_type_code;
3783: EXCEPTION

Line 3793: FROM csi_i_parties

3789: SELECT instance_party_id,
3790: object_version_number
3791: INTO px_party_tbl(l_p_ind).instance_party_id,
3792: px_party_tbl(l_p_ind).object_version_number
3793: FROM csi_i_parties
3794: WHERE instance_id = px_instance_rec.instance_id
3795: AND party_id = px_party_tbl(l_p_ind).party_id
3796: AND party_source_table = px_party_tbl(l_p_ind).party_source_table
3797: AND relationship_type_code = px_party_tbl(l_p_ind).relationship_type_code;

Line 3856: FROM csi_i_parties

3852: END LOOP;
3853: ELSE
3854: SELECT object_version_number
3855: INTO px_party_tbl(l_p_ind).object_version_number
3856: FROM csi_i_parties
3857: WHERE instance_party_id = px_party_tbl(l_p_ind).instance_party_id;
3858: END IF;
3859:
3860: END IF;

Line 6236: FROM csi_i_parties

6232: IF l_owner_party_id is not null THEN
6233:
6234: SELECT party_source_table
6235: INTO l_party_source_table
6236: FROM csi_i_parties
6237: WHERE instance_id = p_instance_id
6238: AND relationship_type_code = 'OWNER';
6239:
6240: FOR l_ind IN px_txn_line_dtl_tbl.FIRST .. px_txn_line_dtl_tbl.LAST