APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_EXPENDITURE_TYPES

Line 1806: --Join to the pa_expenditure_types table.

1802: * ************************************************/
1803: --Bug 3615477
1804: --Also updating the value of fc_res_type_code.
1805: --Bug 3628429
1806: --Join to the pa_expenditure_types table.
1807: -- Fixed bug 3962699 - Removed the setting of fc_res_type_code from
1808: -- all the below selects. No need to set fc res type code - only
1809: -- need to set Exp Type.
1810: UPDATE pa_res_members_temp res_temp

Line 1813: FROM bom_resources bom, pa_expenditure_types exp

1809: -- need to set Exp Type.
1810: UPDATE pa_res_members_temp res_temp
1811: SET res_temp.expenditure_type =
1812: (SELECT exp.expenditure_type
1813: FROM bom_resources bom, pa_expenditure_types exp
1814: WHERE bom.resource_id = res_temp.bom_resource_id
1815: AND exp.expenditure_type = bom.expenditure_type
1816: AND exp.UNIT_OF_MEASURE = 'HOURS'
1817: AND ROWNUM = 1)

Line 1881: --Join to the pa_expenditure_types table.

1877: * and bom_resource_id is not null. We use the below
1878: * Update to set the value for rate_expenditure_type
1879: * ************************************************/
1880: --Bug 3628429
1881: --Join to the pa_expenditure_types table.
1882: UPDATE pa_res_members_temp res_temp
1883: SET res_temp.rate_expenditure_type =
1884: (SELECT exp.expenditure_type
1885: FROM bom_resources bom,pa_expenditure_types exp

Line 1885: FROM bom_resources bom,pa_expenditure_types exp

1881: --Join to the pa_expenditure_types table.
1882: UPDATE pa_res_members_temp res_temp
1883: SET res_temp.rate_expenditure_type =
1884: (SELECT exp.expenditure_type
1885: FROM bom_resources bom,pa_expenditure_types exp
1886: WHERE bom.resource_id = res_temp.bom_resource_id
1887: AND exp.expenditure_type = bom.expenditure_type
1888: AND exp.UNIT_OF_MEASURE = 'HOURS'
1889: AND ROWNUM = 1)

Line 2044: FROM pa_expenditure_types et

2040: * the expenditure type.
2041: ***************************************************************/
2042: UPDATE pa_res_members_temp res_temp
2043: SET res_temp.unit_of_measure = (SELECT unit_of_measure
2044: FROM pa_expenditure_types et
2045: WHERE et.expenditure_type = res_temp.expenditure_type
2046: AND ROWNUM = 1)
2047: WHERE res_temp.resource_class_code IN
2048: ('MATERIAL_ITEMS', 'FINANCIAL_ELEMENTS')

Line 2361: FROM pa_expenditure_types c

2357: * ********************************************************/
2358: UPDATE pa_res_members_temp res_temp
2359: SET rate_based_flag =
2360: (SELECT c.cost_rate_flag
2361: FROM pa_expenditure_types c
2362: WHERE c.expenditure_type = res_temp.expenditure_type)
2363: -- nvl(res_temp.expenditure_type, Bug 3586021
2364: -- res_temp.rate_expenditure_type))
2365: WHERE res_temp.resource_class_code

Line 5002: Pa_Expenditure_Types

4998: Cursor c_Exp_Type ( P_Fin_Cat_Name IN Varchar2) Is
4999: Select
5000: 'Y'
5001: From
5002: Pa_Expenditure_Types
5003: Where
5004: lower(Expenditure_Type) = lower(P_Fin_Cat_Name)
5005: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5006: 'Y',Start_Date_Active,

Line 5045: Pa_Expenditure_Types

5041: Cursor c_UOM ( P_Fin_Cat_Name IN Varchar2 ) Is
5042: Select
5043: 'Y'
5044: From
5045: Pa_Expenditure_Types
5046: Where
5047: Unit_Of_Measure = 'HOURS'
5048: And Expenditure_Type = P_Fin_Cat_Name;
5049:

Line 7344: FROM pa_expenditure_types c

7340: (l_res_details.inventory_item_id IS NULL) THEN
7341:
7342: SELECT c.cost_rate_flag
7343: INTO l_rate_based_flag
7344: FROM pa_expenditure_types c
7345: WHERE c.expenditure_type = l_res_details.expenditure_type;
7346: END IF;
7347:
7348: RETURN l_rate_based_flag;