APPS.QA_PLAN_ELEMENT_API dependencies on BOM_DEPARTMENTS_VAL_V

Line 1021: FROM bom_departments_val_v

1017: id NUMBER;
1018:
1019: CURSOR c (d_code VARCHAR2, o_id NUMBER) IS
1020: SELECT department_id
1021: FROM bom_departments_val_v
1022: WHERE department_code = d_code
1023: AND organization_id = o_id;
1024:
1025: BEGIN

Line 2659: FROM bom_departments_val_v

2655: -- After Single Scan LOV
2656: wild := value;
2657:
2658: sql_string := 'SELECT department_code, description
2659: FROM bom_departments_val_v
2660: WHERE department_code like :1 AND
2661: organization_id = :2
2662: ORDER BY department_code';
2663: OPEN x_ref FOR sql_string USING wild, org_id;