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

3202: object_version_number
3203: INTO l_cur_owner_party_id,
3204: l_owner_pty_ip_id,
3205: l_owner_pty_obj_ver_num
3206: FROM csi_i_parties
3207: WHERE instance_id = l_instances_tbl(i_ind).instance_id
3208: AND relationship_type_code = 'OWNER';
3209:
3210: --## brmanesh leased out internal item may not have a owner account