APPS.PA_CAPITAL_EVENTS_PVT dependencies on PA_PROJECT_TYPES

Line 23: pa_project_types pt

19: p.segment1 project_number,
20: p.name project_name,
21: p.asset_allocation_method
22: FROM pa_projects p,
23: pa_project_types pt
24: WHERE p.project_type = pt.project_type
25: AND pt.project_type_class_code = 'CAPITAL'
26: AND NVL(p.capital_event_processing,'N') = 'P'
27: AND p.project_id = NVL(p_project_id, p.project_id)

Line 128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;

124:
125: curr_project_id NUMBER;
126: curr_capital_type PA_REPORTING_EXCEPTIONS.record_type%TYPE;
127: curr_context PA_REPORTING_EXCEPTIONS.context%TYPE;
128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;
129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;

Line 236: pa_project_types pt

232: --Get Cost Type
233: SELECT pt.capital_cost_type_code
234: INTO v_cost_type
235: FROM pa_projects p,
236: pa_project_types pt
237: WHERE p.project_type = pt.project_type
238: AND p.project_id = report_rec.project_id;
239:
240: END IF;