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 2282: FROM wip_entities

2278: l_update_by NUMBER := fnd_global.user_id;
2279:
2280: CURSOR wip_cur IS
2281: SELECT wip_entity_id, entity_type
2282: FROM wip_entities
2283: WHERE wip_entity_name = p_job_name
2284: AND organization_id = p_organization_id;
2285:
2286: CURSOR item_cur IS

Line 2890: FROM wip_entities

2886: FROM DUAL;
2887:
2888: CURSOR job_cur IS
2889: SELECT wip_entity_id
2890: FROM wip_entities
2891: WHERE wip_entity_name = p_job_name
2892: AND organization_id = l_organization_id;
2893:
2894: CURSOR op_cur IS