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 1719: FROM wip_discrete_jobs_all_v

1715: id NUMBER;
1716:
1717: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1718: SELECT wip_entity_id
1719: FROM wip_discrete_jobs_all_v
1720: WHERE wip_entity_name = w_e_name
1721: AND organization_id = o_id;
1722:
1723: BEGIN

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

2660: wild := value;
2661:
2662:
2663: -- #2382432
2664: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
2665: -- earlier wip_open_discrete_jobs_val_v
2666: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2667:
2668: sql_string := 'SELECT wip_entity_name, description

Line 2669: FROM wip_discrete_jobs_all_v

2665: -- earlier wip_open_discrete_jobs_val_v
2666: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2667:
2668: sql_string := 'SELECT wip_entity_name, description
2669: FROM wip_discrete_jobs_all_v
2670: WHERE wip_entity_name like :1 AND
2671: organization_id = :2
2672: ORDER BY wip_entity_name';
2673: OPEN x_ref FOR sql_string USING wild, org_id;

Line 3989: FROM wip_discrete_jobs_all_v

3985: -- After Single Scan LOV
3986: wild := value;
3987:
3988: sql_string := 'SELECT wip_entity_name, description
3989: FROM wip_discrete_jobs_all_v
3990: WHERE wip_entity_name like :1 AND
3991: organization_id = :2
3992: ORDER BY wip_entity_name';
3993: OPEN x_ref FOR sql_string USING wild, org_id;