APPS.PA_FAXFACE dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;

1922: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
1923:
1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
1927: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
1928: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
1929: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
1930:

Line 4111: FROM pa_project_asset_lines_all pal,

4107: pce.capital_event_number,
4108: pce.event_name,
4109: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4110: pal.asset_category_id /* Added for bug#3211946 */
4111: FROM pa_project_asset_lines_all pal,
4112: pa_projects p,
4113: pa_capital_events pce
4114: WHERE pal.project_id = p.project_id
4115: AND p.project_id = x_project_id