DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PJM_COMMITMENT_UTILS

Line 1860: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(

1856: --Bug 3615477
1857: --Also updating the value of fc_res_type_code.
1858: UPDATE pa_res_members_temp res_temp
1859: SET res_temp.expenditure_type =
1860: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(
1861: res_temp.organization_id, res_temp.inventory_item_id)
1862: WHERE res_temp.organization_id IS NOT NULL
1863: AND res_temp.inventory_item_id IS NOT NULL
1864: AND res_temp.expenditure_type IS NULL;

Line 1928: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(

1924: -- Get the item's exp type if it exists
1925:
1926: UPDATE pa_res_members_temp res_temp
1927: SET res_temp.rate_expenditure_type =
1928: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(
1929: res_temp.organization_id, res_temp.inventory_item_id)
1930: WHERE res_temp.organization_id IS NOT NULL
1931: AND res_temp.inventory_item_id IS NOT NULL
1932: AND res_temp.rate_expenditure_type IS NULL;