DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on WIP_ENTITIES

Line 1544: FROM wip_entities WE, wip_discrete_jobs WDJ

1540:
1541: /* rkaza 10/21/2002. Bug 2635736 */
1542: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1543: SELECT WDJ.wip_entity_id
1544: FROM wip_entities WE, wip_discrete_jobs WDJ
1545: WHERE WDJ.status_type in (3,4) and
1546: WDJ.wip_entity_id = WE.wip_entity_id and
1547: WE.entity_type IN (6, 7) and
1548: WE.wip_entity_name = w_e_name

Line 2697: from wip_entities WE, wip_discrete_jobs WDJ

2693: wild := value;
2694:
2695: /* rkaza 10/21/2002. Bug 2635736 */
2696: sql_string := 'select WE.wip_entity_name, WDJ.description
2697: from wip_entities WE, wip_discrete_jobs WDJ
2698: where WDJ.organization_id = :1 and
2699: WDJ.status_type in (3,4) and
2700: WDJ.wip_entity_id = WE.wip_entity_id and
2701: WE.entity_type IN (6, 7) and