DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

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

1977:
1978: /*********************************************************
1979: * Procedure : Default_OU
1980: * Description : To derive the default Org ID
1981: * First it will try to derive it from hr_organization_information
1982: * based on the organization_id.
1983: * If the Org_id is still null then we will get it based on the p_project_id
1984: * passed from pa_projects_all table.
1985: * ******************************************************/

Line 1992: FROM hr_organization_information

1988: l_proj_ou NUMBER;
1989: BEGIN
1990: UPDATE pa_res_members_temp res_temp
1991: SET org_id = (SELECT to_number(org_information1)
1992: FROM hr_organization_information
1993: WHERE org_information_context = 'Exp Organization Defaults'
1994: AND organization_id = res_temp.organization_id
1995: AND rownum = 1)
1996: WHERE res_temp.organization_id IS NOT NULL