APPS.CSD_RULES_ENGINE_PVT dependencies on CS_INCIDENTS_B_SEC

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

1137: a.contract_id,
1138: a.problem_code,
1139: a.customer_product_id,
1140: b.inventory_item_id -- swai: 12.1.1 ER 7233924
1141: FROM CSD_INCIDENTS_V a, CSD_REPAIRS b, CS_INCIDENTS_B_SEC c
1142: WHERE a.incident_id = b.incident_id
1143: AND a.incident_id = c.incident_id
1144: AND b.repair_line_Id = p_repair_line_id;
1145: BEGIN

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

1932: l_str_condition VARCHAR2(3000); -- for conditions that match a string type
1933: l_condition_count NUMBER :=0;
1934:
1935: BEGIN
1936: l_sql_query := 'select dra.repair_line_id from csd_repairs dra, cs_incidents_b_sec csb '
1937: || 'where csb.incident_id = dra.incident_id';
1938: OPEN c_rule_conditions(p_rule_id);
1939: LOOP
1940: FETCH c_rule_conditions into l_rule_condition_rec;