APPS.AHL_UC_INSTANCE_PVT dependencies on CSI_I_PARTIES

Line 2360: FROM csi_item_instances csi, csi_i_parties p

2356: party_id,
2357: party_source_table,
2358: instance_party_id,
2359: csi.wip_job_id
2360: FROM csi_item_instances csi, csi_i_parties p
2361: WHERE csi.instance_id = p.instance_id
2362: AND p.relationship_type_code = 'OWNER'
2363: AND csi.instance_id = c_csi_instance_id
2364: AND trunc(SYSDATE) < trunc(nvl(csi.active_end_date, SYSDATE+1));

Line 6226: FROM csi_item_instances csi, csi_i_parties p

6222: party_id,
6223: party_source_table,
6224: instance_party_id,
6225: csi.wip_job_id
6226: FROM csi_item_instances csi, csi_i_parties p
6227: WHERE csi.instance_id = p.instance_id
6228: AND p.relationship_type_code = 'OWNER'
6229: AND csi.instance_id = p_csi_instance_id
6230: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);