APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_NON_LABOR_RESOURCES

Line 1572: FROM pa_non_labor_resources

1568: ELSIF p_res_type_code = 'NON_LABOR_RESOURCE' THEN
1569: BEGIN
1570: SELECT non_labor_resource
1571: INTO x_non_labor_resource
1572: FROM pa_non_labor_resources
1573: WHERE non_labor_resource = p_resource_name;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1831: FROM pa_non_labor_resources n

1827: --Also updating the value of fc_res_type_code.
1828: UPDATE pa_res_members_temp res_temp
1829: SET res_temp.expenditure_type =
1830: (SELECT n.expenditure_type
1831: FROM pa_non_labor_resources n
1832: WHERE n.non_labor_resource =
1833: res_temp.non_labor_resource
1834: AND ROWNUM = 1)
1835: WHERE res_temp.expenditure_type IS NULL

Line 1900: FROM pa_non_labor_resources n

1896: *************************************************/
1897: UPDATE pa_res_members_temp res_temp
1898: SET res_temp.rate_expenditure_type =
1899: (SELECT n.expenditure_type
1900: FROM pa_non_labor_resources n
1901: WHERE n.non_labor_resource =
1902: res_temp.non_labor_resource
1903: AND ROWNUM = 1)
1904: WHERE res_temp.rate_expenditure_type IS NULL

Line 7703: FROM pa_non_labor_resources n

7699: IF l_fmt_details.Fin_Cat_Enabled_Flag = 'Y' THEN
7700: -- Get the Fin Cat
7701: SELECT n.expenditure_type
7702: INTO x_expenditure_type
7703: FROM pa_non_labor_resources n
7704: WHERE n.non_labor_resource = p_non_labor_resource
7705: AND ROWNUM = 1;
7706:
7707: END IF;