APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 252: FROM mtl_parameters a, hr_all_organization_units hou

248: ================================================*/
249:
250: CURSOR get_org_data (v_org_id NUMBER) IS
251: SELECT a.organization_code, hou.name organization_name
252: FROM mtl_parameters a, hr_all_organization_units hou
253: WHERE
254: a.organization_id = v_org_id
255: AND a.organization_id = hou.organization_id;
256:

Line 258: l_orgn_name hr_all_organization_units.name%TYPE;

254: a.organization_id = v_org_id
255: AND a.organization_id = hou.organization_id;
256:
257: l_orgn_code mtl_parameters.organization_code%TYPE;
258: l_orgn_name hr_all_organization_units.name%TYPE;
259:
260:
261: CURSOR get_item_data (v_itemorg NUMBER, v_item_id NUMBER) IS
262: select concatenated_segments item_number, description item_description

Line 311: HR_ALL_ORGANIZATION_UNITS hou

307: GMD_QC_STATUS_TL t,
308: GEM_LOOKUPS src_type ,
309: MTL_ITEM_LOCATIONS_KFV locations,
310: MTL_PARAMETERS a,
311: HR_ALL_ORGANIZATION_UNITS hou
312: WHERE V.SPEC_ID = S.SPEC_ID
313: AND s.spec_status = p.status_code
314: AND p.entity_type = 'S'
315: AND p.language = USERENV('LANG')