APPS.AHL_UC_INSTANCE_PVT dependencies on CSI_I_PARTIES

Line 2359: FROM csi_item_instances csi, csi_i_parties p

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

Line 6119: FROM csi_item_instances csi, csi_i_parties p

6115: party_id,
6116: party_source_table,
6117: instance_party_id,
6118: csi.wip_job_id
6119: FROM csi_item_instances csi, csi_i_parties p
6120: WHERE csi.instance_id = p.instance_id
6121: AND p.relationship_type_code = 'OWNER'
6122: AND csi.instance_id = p_csi_instance_id
6123: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);