APPS.PA_FAXFACE dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 1237: (select 1 from pa_project_asset_lines_all lines,

1233: set ei.capital_event_id = null
1234: where ei.revenue_distributed_flag = 'N'
1235: and ei.capital_event_id = -1
1236: and EXISTS
1237: (select 1 from pa_project_asset_lines_all lines,
1238: pa_project_asset_line_Details det
1239: where lines.project_id=ei.project_id
1240: and det.expenditure_item_id= ei.expenditure_item_id
1241: and det.REVERSED_FLAG='N'

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

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;
2175:

Line 4495: FROM pa_project_asset_lines_all pal,

4491: pce.capital_event_number,
4492: pce.event_name,
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

Line 6067: FROM PA_PROJECT_ASSET_LINES_ALL LINES,

6063: AND cdl.billable_flag ||''='Y'
6064: AND EXISTS
6065: (
6066: SELECT 1
6067: FROM PA_PROJECT_ASSET_LINES_ALL LINES,
6068: PA_PROJECT_ASSET_LINE_DETAILS DET
6069: WHERE Det.expenditure_item_id = cdl.expenditure_item_id
6070: AND DET.LINE_NUM = CDL.LINE_NUM_REVERSED
6071: AND lines.transfer_status_code = 'T'

Line 6075: FROM pa_project_asset_lines_all lines,

6071: AND lines.transfer_status_code = 'T'
6072: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id
6073: AND NOT EXISTS
6074: (SELECT NULL
6075: FROM pa_project_asset_lines_all lines,
6076: pa_project_asset_line_details det
6077: WHERE det.expenditure_item_id = cdl.expenditure_item_id
6078: AND det.line_num = cdl.line_num
6079: AND lines.transfer_status_code = 'T'