DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PA_CAPITAL_EVENTS

Line 1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;

1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
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;

Line 1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;

1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
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;

Line 1927: extn_capital_event_id pa_capital_events.capital_event_id%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:
1931: extn_project_id number(15);

Line 4113: pa_capital_events pce

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
4116: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
4117: AND pal.capital_event_id = pce.capital_event_id (+)