APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_I_PARTIES

Line 127: FROM csi_i_parties

123: object_version_number
124: INTO px_inst_pa_rec.party_id,
125: px_inst_pa_rec.instance_party_id,
126: px_inst_pa_rec.pty_obj_version
127: FROM csi_i_parties
128: WHERE instance_id = px_inst_pa_rec.instance_id
129: AND relationship_type_code = 'OWNER'
130: AND sysdate between nvl(active_end_date,sysdate) and sysdate+1 ;
131: px_inst_pa_rec.party_rltnshp_code := 'OWNER';

Line 3167: FROM csi_i_parties

3163: object_version_number
3164: INTO l_cur_owner_party_id,
3165: l_owner_pty_ip_id,
3166: l_owner_pty_obj_ver_num
3167: FROM csi_i_parties
3168: WHERE instance_id = l_instances_tbl(i_ind).instance_id
3169: AND relationship_type_code = 'OWNER';
3170:
3171: --## brmanesh leased out internal item may not have a owner account