APPS.AHL_UMP_NONROUTINES_PVT dependencies on BOM_DEPARTMENTS

Line 2244: from bom_departments

2240: p_org_id number
2241: )
2242: IS
2243: select department_id
2244: from bom_departments
2245: where organization_id = p_org_id and
2246: department_code = p_dept_code;
2247:
2248: CURSOR check_dept_id

Line 2255: from bom_departments

2251: p_org_id number
2252: )
2253: IS
2254: select 'x'
2255: from bom_departments
2256: where organization_id = p_org_id and
2257: department_id = p_dept_id;
2258:
2259: CURSOR check_ue_mel_cdl_approved