DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 1941: * First it will try to derive it from hr_organization_information

1937:
1938: /*********************************************************
1939: * Procedure : Default_OU
1940: * Description : To derive the default Org ID
1941: * First it will try to derive it from hr_organization_information
1942: * based on the organization_id.
1943: * If the Org_id is still null then we will get it based on the p_project_id
1944: * passed from pa_projects_all table.
1945: * ******************************************************/

Line 1952: FROM hr_organization_information

1948: l_proj_ou NUMBER;
1949: BEGIN
1950: UPDATE pa_res_members_temp res_temp
1951: SET org_id = (SELECT to_number(org_information1)
1952: FROM hr_organization_information
1953: WHERE org_information_context = 'Exp Organization Defaults'
1954: AND organization_id = res_temp.organization_id
1955: AND rownum = 1)
1956: WHERE res_temp.organization_id IS NOT NULL