DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on FND_GLOBAL

Line 1781: AND fgs.grantee_key = FND_GLOBAL.USER_NAME

1777: , fnd_objects fos
1778: WHERE fgs.object_id = fos.object_id
1779: AND fgs.menu_id = fmu.menu_id
1780: AND fos.obj_name = 'CAC_CAL_RESOURCES'
1781: AND fgs.grantee_key = FND_GLOBAL.USER_NAME
1782: AND fgs.grantee_type = 'USER'
1783: AND fgs.start_date < SYSDATE
1784: AND ( fgs.end_date >= SYSDATE
1785: OR fgs.end_date IS NULL

Line 1825: l_user_id := fnd_global.user_id;

1821: ELSE
1822: IF p_input.UserID IS NOT NULL THEN
1823: l_user_id := p_input.UserID;
1824: ELSE
1825: l_user_id := fnd_global.user_id;
1826: END IF;
1827:
1828: -- Get an employee resource info for the given user id
1829: Jtf_Cal_Utility_Pvt.GetResourceInfo

Line 1845: ( p_UserID => fnd_global.user_id

1841: END IF;
1842:
1843: -- Get an employee resource info for the loggon user
1844: Jtf_Cal_Utility_Pvt.GetResourceInfo
1845: ( p_UserID => fnd_global.user_id
1846: , x_ResourceID => x_loggedon_emp_resource_id
1847: , x_ResourceType => x_loggedon_emp_resource_type
1848: );
1849: