DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on WIP_ENTITIES

Line 180: FROM WIP_ENTITIES we, WIP_JOB_SCHEDULE_INTERFACE wjsi

176:
177: /*
178: CURSOR job_cur IS
179: SELECT we.wip_entity_id
180: FROM WIP_ENTITIES we, WIP_JOB_SCHEDULE_INTERFACE wjsi
181: WHERE wjsi.process_status = 4
182: AND wjsi.group_id = l_group_id
183: AND we.wip_entity_id = wjsi.wip_entity_id;
184: */

Line 2286: FROM wip_entities

2282: l_update_by NUMBER := fnd_global.user_id;
2283:
2284: CURSOR wip_cur IS
2285: SELECT wip_entity_id, entity_type
2286: FROM wip_entities
2287: WHERE wip_entity_name = p_job_name
2288: AND organization_id = p_organization_id;
2289:
2290: CURSOR item_cur IS

Line 2906: FROM wip_entities

2902: FROM DUAL;
2903:
2904: CURSOR job_cur IS
2905: SELECT wip_entity_id
2906: FROM wip_entities
2907: WHERE wip_entity_name = p_job_name
2908: AND organization_id = l_organization_id;
2909:
2910: CURSOR op_cur IS