DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PA_CAPITAL_EVENTS

Line 2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;

2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263
2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;

Line 2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;

2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263
2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;

Line 2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;

2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
2175:
2176: extn_project_id number(15);

Line 4497: pa_capital_events pce

4493: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4494: pal.asset_category_id /* Added for bug#3211946 */
4495: FROM pa_project_asset_lines_all pal,
4496: pa_projects p,
4497: pa_capital_events pce
4498: WHERE pal.project_id = p.project_id
4499: AND p.project_id = x_project_id
4500: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
4501: AND pal.capital_event_id = pce.capital_event_id (+)