APPS.QA_PLAN_ELEMENT_API dependencies on WIP_DISCRETE_JOBS_ALL_V

Line 1046: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of

1042:
1043: id NUMBER;
1044:
1045: -- #2382432
1046: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
1047: -- earlier wip_open_discrete_jobs_val_v
1048: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
1049:
1050: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS

Line 1052: FROM wip_discrete_jobs_all_v

1048: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
1049:
1050: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1051: SELECT wip_entity_id
1052: FROM wip_discrete_jobs_all_v
1053: WHERE wip_entity_name = w_e_name
1054: AND organization_id = o_id;
1055:
1056: BEGIN

Line 1738: FROM wip_discrete_jobs_all_v

1734: id NUMBER;
1735:
1736: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1737: SELECT wip_entity_id
1738: FROM wip_discrete_jobs_all_v
1739: WHERE wip_entity_name = w_e_name
1740: AND organization_id = o_id;
1741:
1742: BEGIN

Line 2688: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of

2684: wild := value;
2685:
2686:
2687: -- #2382432
2688: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
2689: -- earlier wip_open_discrete_jobs_val_v
2690: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2691:
2692: sql_string := 'SELECT wip_entity_name, description

Line 2693: FROM wip_discrete_jobs_all_v

2689: -- earlier wip_open_discrete_jobs_val_v
2690: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2691:
2692: sql_string := 'SELECT wip_entity_name, description
2693: FROM wip_discrete_jobs_all_v
2694: WHERE wip_entity_name like :1 AND
2695: organization_id = :2
2696: ORDER BY wip_entity_name';
2697: OPEN x_ref FOR sql_string USING wild, org_id;

Line 4187: FROM wip_discrete_jobs_all_v

4183: -- After Single Scan LOV
4184: wild := value;
4185:
4186: sql_string := 'SELECT wip_entity_name, description
4187: FROM wip_discrete_jobs_all_v
4188: WHERE wip_entity_name like :1 AND
4189: organization_id = :2
4190: ORDER BY wip_entity_name';
4191: OPEN x_ref FOR sql_string USING wild, org_id;