APPS.CSD_RULES_ENGINE_PVT dependencies on CS_INCIDENTS_B_SEC

Line 1659: FROM CSD_INCIDENTS_V a, CSD_REPAIRS b, CS_INCIDENTS_B_SEC c

1655: b.contract_line_id,
1656: b.flow_status_id,
1657: b.resource_id,
1658: b.ro_priority_code
1659: FROM CSD_INCIDENTS_V a, CSD_REPAIRS b, CS_INCIDENTS_B_SEC c
1660: WHERE a.incident_id = b.incident_id
1661: AND a.incident_id = c.incident_id
1662: AND b.repair_line_Id = p_repair_line_id;
1663:

Line 2508: l_sql_query := 'select dra.repair_line_id from csd_repairs dra, cs_incidents_b_sec csb '

2504: l_str_condition VARCHAR2(3000); -- for conditions that match a string type
2505: l_condition_count NUMBER :=0;
2506:
2507: BEGIN
2508: l_sql_query := 'select dra.repair_line_id from csd_repairs dra, cs_incidents_b_sec csb '
2509: || 'where csb.incident_id = dra.incident_id';
2510: OPEN c_rule_conditions(p_rule_id);
2511: LOOP
2512: FETCH c_rule_conditions into l_rule_condition_rec;