DBA Data[Home] [Help]

APPS.FTE_MLS_UTIL dependencies on MTL_PARAMETERS

Line 2652: FROM hr_organization_units hou,mtl_parameters mp

2648: BEGIN
2649:
2650: SELECT mp. organization_id
2651: INTO l_organization_id
2652: FROM hr_organization_units hou,mtl_parameters mp
2653: WHERE hou.organization_id = mp.organization_id
2654: AND hou.location_id = p_entity_id
2655: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
2656:

Line 3106: FROM hr_organization_units hou,mtl_parameters mp

3102: l_number_of_errors NUMBER;
3103:
3104: CURSOR GET_ORG_ID_BY_LOCATION (l_stop_loc_id NUMBER) IS
3105: SELECT mp. organization_id
3106: FROM hr_organization_units hou,mtl_parameters mp
3107: WHERE hou.organization_id = mp.organization_id
3108: AND hou.location_id = l_stop_loc_id
3109: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
3110: