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 2635: FROM bom_departments_val_v

2631: -- After Single Scan LOV
2632: wild := value;
2633:
2634: sql_string := 'SELECT department_code, description
2635: FROM bom_departments_val_v
2636: WHERE department_code like :1 AND
2637: organization_id = :2
2638: ORDER BY department_code';
2639: OPEN x_ref FOR sql_string USING wild, org_id;