DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on WIP_ENTITIES

Line 1563: FROM wip_entities WE, wip_discrete_jobs WDJ

1559:
1560: /* rkaza 10/21/2002. Bug 2635736 */
1561: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1562: SELECT WDJ.wip_entity_id
1563: FROM wip_entities WE, wip_discrete_jobs WDJ
1564: WHERE WDJ.status_type in (3,4) and
1565: WDJ.wip_entity_id = WE.wip_entity_id and
1566: WE.entity_type IN (6, 7) and
1567: WE.wip_entity_name = w_e_name

Line 2721: from wip_entities WE, wip_discrete_jobs WDJ

2717: wild := value;
2718:
2719: /* rkaza 10/21/2002. Bug 2635736 */
2720: sql_string := 'select WE.wip_entity_name, WDJ.description
2721: from wip_entities WE, wip_discrete_jobs WDJ
2722: where WDJ.organization_id = :1 and
2723: WDJ.status_type in (3,4) and
2724: WDJ.wip_entity_id = WE.wip_entity_id and
2725: WE.entity_type IN (6, 7) and