APPS.IPA_CLIENT_EXTENSION_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 425: l_expenditure_type pa_expenditure_items_all.expenditure_type%TYPE;

421: x_error_message IN OUT NOCOPY VARCHAR2) IS
422:
423: -- Define local variables
424:
425: l_expenditure_type pa_expenditure_items_all.expenditure_type%TYPE;
426: l_raw_cost pa_expenditure_items_all.raw_cost%TYPE;
427: l_quantity pa_expenditure_items_all.quantity%TYPE;
428: l_project_Asset_line_id pa_project_asset_lines_all.project_asset_line_id%TYPE;
429:

Line 426: l_raw_cost pa_expenditure_items_all.raw_cost%TYPE;

422:
423: -- Define local variables
424:
425: l_expenditure_type pa_expenditure_items_all.expenditure_type%TYPE;
426: l_raw_cost pa_expenditure_items_all.raw_cost%TYPE;
427: l_quantity pa_expenditure_items_all.quantity%TYPE;
428: l_project_Asset_line_id pa_project_asset_lines_all.project_asset_line_id%TYPE;
429:
430: CURSOR get_exp_item_details IS

Line 427: l_quantity pa_expenditure_items_all.quantity%TYPE;

423: -- Define local variables
424:
425: l_expenditure_type pa_expenditure_items_all.expenditure_type%TYPE;
426: l_raw_cost pa_expenditure_items_all.raw_cost%TYPE;
427: l_quantity pa_expenditure_items_all.quantity%TYPE;
428: l_project_Asset_line_id pa_project_asset_lines_all.project_asset_line_id%TYPE;
429:
430: CURSOR get_exp_item_details IS
431: SELECT pei.expenditure_type,pei.raw_cost,pei.quantity

Line 433: pa_expenditure_items pei,

429:
430: CURSOR get_exp_item_details IS
431: SELECT pei.expenditure_type,pei.raw_cost,pei.quantity
432: FROM pa_project_asset_lines ppal,
433: pa_expenditure_items pei,
434: pa_project_asset_line_details ppald
435: WHERE ppal.project_Asset_line_id = l_project_Asset_line_id
436: AND ppal.project_asset_line_detail_id= ppald.project_asset_line_detail_id
437: AND pei.expenditure_item_id = ppald.expenditure_item_id