DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 7320: FROM mtl_employees_current_view mec,

7316: SELECT mec.full_name,
7317: fus.employee_id
7318: INTO l_employee_full_name,
7319: l_employee_id
7320: FROM mtl_employees_current_view mec,
7321: fnd_user fus
7322: WHERE fus.user_id = l_user_id
7323: AND mec.employee_id = fus.employee_id
7324: AND mec.organization_id = l_org_id;

Line 7328: -- is not properly defined in the MTL_EMPLOYEES_CURRENT_VIEW

7324: AND mec.organization_id = l_org_id;
7325: EXCEPTION
7326: WHEN NO_DATA_FOUND THEN
7327: -- Just get the employee ID if the employee
7328: -- is not properly defined in the MTL_EMPLOYEES_CURRENT_VIEW
7329: SELECT fus.employee_id
7330: INTO l_employee_id
7331: FROM fnd_user fus
7332: WHERE fus.user_id = l_user_id;