DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSI_I_PARTIES

Line 1577: csi_i_parties cip

1573: */
1574: CURSOR c1 IS
1575: SELECT 'X'
1576: FROM cs_incidents_all_b sr,
1577: csi_i_parties cip
1578: WHERE sr.incident_id = p_incident_id
1579: AND cip.instance_id = p_customer_product_id
1580: AND sr.customer_id = cip.party_id
1581: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(cip.active_start_date,sysdate))