APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_EXPENDITURE_TYPES

Line 1822: --Join to the pa_expenditure_types table.

1818: * ************************************************/
1819: --Bug 3615477
1820: --Also updating the value of fc_res_type_code.
1821: --Bug 3628429
1822: --Join to the pa_expenditure_types table.
1823: -- Fixed bug 3962699 - Removed the setting of fc_res_type_code from
1824: -- all the below selects. No need to set fc res type code - only
1825: -- need to set Exp Type.
1826: UPDATE pa_res_members_temp res_temp

Line 1829: FROM bom_resources bom, pa_expenditure_types exp

1825: -- need to set Exp Type.
1826: UPDATE pa_res_members_temp res_temp
1827: SET res_temp.expenditure_type =
1828: (SELECT exp.expenditure_type
1829: FROM bom_resources bom, pa_expenditure_types exp
1830: WHERE bom.resource_id = res_temp.bom_resource_id
1831: AND exp.expenditure_type = bom.expenditure_type
1832: AND exp.UNIT_OF_MEASURE = 'HOURS'
1833: AND ROWNUM = 1)

Line 1898: --Join to the pa_expenditure_types table.

1894: * and bom_resource_id is not null. We use the below
1895: * Update to set the value for rate_expenditure_type
1896: * ************************************************/
1897: --Bug 3628429
1898: --Join to the pa_expenditure_types table.
1899: UPDATE pa_res_members_temp res_temp
1900: SET res_temp.rate_expenditure_type =
1901: (SELECT exp.expenditure_type
1902: FROM bom_resources bom,pa_expenditure_types exp

Line 1902: FROM bom_resources bom,pa_expenditure_types exp

1898: --Join to the pa_expenditure_types table.
1899: UPDATE pa_res_members_temp res_temp
1900: SET res_temp.rate_expenditure_type =
1901: (SELECT exp.expenditure_type
1902: FROM bom_resources bom,pa_expenditure_types exp
1903: WHERE bom.resource_id = res_temp.bom_resource_id
1904: AND exp.expenditure_type = bom.expenditure_type
1905: AND exp.UNIT_OF_MEASURE = 'HOURS'
1906: AND ROWNUM = 1)

Line 2084: FROM pa_expenditure_types et

2080: * the expenditure type.
2081: ***************************************************************/
2082: UPDATE pa_res_members_temp res_temp
2083: SET res_temp.unit_of_measure = (SELECT unit_of_measure
2084: FROM pa_expenditure_types et
2085: WHERE et.expenditure_type = res_temp.expenditure_type
2086: AND ROWNUM = 1)
2087: WHERE res_temp.resource_class_code IN
2088: ('MATERIAL_ITEMS', 'FINANCIAL_ELEMENTS')

Line 2402: FROM pa_expenditure_types c

2398: * ********************************************************/
2399: UPDATE pa_res_members_temp res_temp
2400: SET rate_based_flag =
2401: (SELECT c.cost_rate_flag
2402: FROM pa_expenditure_types c
2403: WHERE c.expenditure_type = res_temp.expenditure_type)
2404: -- nvl(res_temp.expenditure_type, Bug 3586021
2405: -- res_temp.rate_expenditure_type))
2406: WHERE res_temp.resource_class_code

Line 5060: Pa_Expenditure_Types

5056: Cursor c_Exp_Type ( P_Fin_Cat_Name IN Varchar2) Is
5057: Select
5058: 'Y'
5059: From
5060: Pa_Expenditure_Types
5061: Where
5062: lower(Expenditure_Type) = lower(P_Fin_Cat_Name)
5063: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5064: 'Y',Start_Date_Active,

Line 5103: Pa_Expenditure_Types

5099: Cursor c_UOM ( P_Fin_Cat_Name IN Varchar2 ) Is
5100: Select
5101: 'Y'
5102: From
5103: Pa_Expenditure_Types
5104: Where
5105: Unit_Of_Measure = 'HOURS'
5106: And Expenditure_Type = P_Fin_Cat_Name;
5107:

Line 7502: FROM pa_expenditure_types c

7498: (l_res_details.inventory_item_id IS NULL) THEN
7499:
7500: SELECT c.cost_rate_flag
7501: INTO l_rate_based_flag
7502: FROM pa_expenditure_types c
7503: WHERE c.expenditure_type = l_res_details.expenditure_type;
7504: END IF;
7505:
7506: RETURN l_rate_based_flag;