APPS.AHL_UMP_NONROUTINES_PVT dependencies on BOM_DEPARTMENTS

Line 2150: from bom_departments

2146: p_org_id number
2147: )
2148: IS
2149: select department_id
2150: from bom_departments
2151: where organization_id = p_org_id and
2152: department_code = p_dept_code;
2153:
2154: CURSOR check_dept_id

Line 2161: from bom_departments

2157: p_org_id number
2158: )
2159: IS
2160: select 'x'
2161: from bom_departments
2162: where organization_id = p_org_id and
2163: department_id = p_dept_id;
2164:
2165: CURSOR check_ue_mel_cdl_approved