DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1402: FROM HR_ALL_ORGANIZATION_UNITS_TL tl,mtl_parameters p

1398:
1399:
1400: /*CURSOR C_GET_ORG(p_ORG_ID NUMBER) IS
1401: SELECT p.master_organization_id,tl.NAME
1402: FROM HR_ALL_ORGANIZATION_UNITS_TL tl,mtl_parameters p
1403: WHERE LANGUAGE = asg_base.get_language(p_user_name)
1404: AND tl.ORGANIZATION_ID = p.master_organization_id
1405: AND p.ORGANIZATION_ID =p_org_id;*/
1406:

Line 1409: FROM HR_ALL_ORGANIZATION_UNITS_TL tl

1405: AND p.ORGANIZATION_ID =p_org_id;*/
1406:
1407: CURSOR C_GET_ORG(p_ORG_ID NUMBER) IS
1408: SELECT tl.organization_id,tl.NAME
1409: FROM HR_ALL_ORGANIZATION_UNITS_TL tl
1410: WHERE LANGUAGE = asg_base.get_language(p_user_name)
1411: AND tl.ORGANIZATION_ID = p_org_id;
1412:
1413: