APPS.CSI_INTERFACE_PKG dependencies on CSI_I_PARTIES

Line 3357: FROM csi_i_parties

3353: IF nvl(l_i_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num Then
3354: BEGIN
3355: SELECT instance_party_id
3356: INTO p_txn_party_tbl(l_pc_ind).contact_party_id
3357: FROM csi_i_parties
3358: WHERE instance_id = l_i_rec.instance_id
3359: AND relationship_type_code = p_txn_party_tbl(l_p_ind).relationship_type_code
3360: AND ((active_end_date is null ) OR
3361: (active_end_date > sysdate));

Line 3687: FROM csi_i_parties

3683: SELECT instance_party_id,
3684: object_version_number
3685: INTO px_party_tbl(l_p_ind).instance_party_id,
3686: px_party_tbl(l_p_ind).object_version_number
3687: FROM csi_i_parties
3688: WHERE instance_id = px_instance_rec.instance_id
3689: AND party_source_table = px_party_tbl(l_p_ind).party_source_table
3690: AND relationship_type_code = px_party_tbl(l_p_ind).relationship_type_code;
3691: EXCEPTION

Line 3701: FROM csi_i_parties

3697: SELECT instance_party_id,
3698: object_version_number
3699: INTO px_party_tbl(l_p_ind).instance_party_id,
3700: px_party_tbl(l_p_ind).object_version_number
3701: FROM csi_i_parties
3702: WHERE instance_id = px_instance_rec.instance_id
3703: AND party_id = px_party_tbl(l_p_ind).party_id
3704: AND party_source_table = px_party_tbl(l_p_ind).party_source_table
3705: AND relationship_type_code = px_party_tbl(l_p_ind).relationship_type_code;

Line 3764: FROM csi_i_parties

3760: END LOOP;
3761: ELSE
3762: SELECT object_version_number
3763: INTO px_party_tbl(l_p_ind).object_version_number
3764: FROM csi_i_parties
3765: WHERE instance_party_id = px_party_tbl(l_p_ind).instance_party_id;
3766: END IF;
3767:
3768: END IF;

Line 6129: FROM csi_i_parties

6125: IF l_owner_party_id is not null THEN
6126:
6127: SELECT party_source_table
6128: INTO l_party_source_table
6129: FROM csi_i_parties
6130: WHERE instance_id = p_instance_id
6131: AND relationship_type_code = 'OWNER';
6132:
6133: FOR l_ind IN px_txn_line_dtl_tbl.FIRST .. px_txn_line_dtl_tbl.LAST