APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_NON_LABOR_RESOURCES

Line 1585: FROM pa_non_labor_resources

1581: ELSIF p_res_type_code = 'NON_LABOR_RESOURCE' THEN
1582: BEGIN
1583: SELECT non_labor_resource
1584: INTO x_non_labor_resource
1585: FROM pa_non_labor_resources
1586: WHERE non_labor_resource = p_resource_name;
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1847: FROM pa_non_labor_resources n

1843: --Also updating the value of fc_res_type_code.
1844: UPDATE pa_res_members_temp res_temp
1845: SET res_temp.expenditure_type =
1846: (SELECT n.expenditure_type
1847: FROM pa_non_labor_resources n
1848: WHERE n.non_labor_resource =
1849: res_temp.non_labor_resource
1850: AND ROWNUM = 1)
1851: WHERE res_temp.expenditure_type IS NULL

Line 1917: FROM pa_non_labor_resources n

1913: *************************************************/
1914: UPDATE pa_res_members_temp res_temp
1915: SET res_temp.rate_expenditure_type =
1916: (SELECT n.expenditure_type
1917: FROM pa_non_labor_resources n
1918: WHERE n.non_labor_resource =
1919: res_temp.non_labor_resource
1920: AND ROWNUM = 1)
1921: WHERE res_temp.rate_expenditure_type IS NULL

Line 7861: FROM pa_non_labor_resources n

7857: IF l_fmt_details.Fin_Cat_Enabled_Flag = 'Y' THEN
7858: -- Get the Fin Cat
7859: SELECT n.expenditure_type
7860: INTO x_expenditure_type
7861: FROM pa_non_labor_resources n
7862: WHERE n.non_labor_resource = p_non_labor_resource
7863: AND ROWNUM = 1;
7864:
7865: END IF;