DBA Data[Home] [Help]

APPS.EAM_WL_UTIL_PKG dependencies on WIP_DISCRETE_JOBS

Line 94: FROM wip_discrete_jobs

90: FUNCTION get_wo_status( p_wip_entity_id NUMBER) RETURN VARCHAR2
91: IS
92: CURSOR get_value IS
93: SELECT status_type
94: FROM wip_discrete_jobs
95: WHERE wip_entity_id = p_wip_entity_id;
96:
97: l_status_type wip_discrete_jobs.status_type%TYPE;
98: BEGIN

Line 97: l_status_type wip_discrete_jobs.status_type%TYPE;

93: SELECT status_type
94: FROM wip_discrete_jobs
95: WHERE wip_entity_id = p_wip_entity_id;
96:
97: l_status_type wip_discrete_jobs.status_type%TYPE;
98: BEGIN
99: OPEN get_value;
100: FETCH get_value INTO l_status_type;
101: CLOSE get_value;