APPS.PA_CAPITAL_EVENTS_PVT dependencies on PA_PROJECTS

Line 22: FROM pa_projects p,

18: SELECT p.project_id,
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'

Line 42: v_project_number pa_projects_all.segment1%TYPE;

38: v_null_rowid ROWID := NULL;
39: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
40: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
41:
42: v_project_number pa_projects_all.segment1%TYPE;
43: v_ret_assets_count NUMBER := 0;
44: v_ret_tasks_count NUMBER := 0;
45: v_return_status VARCHAR2(1);
46: v_msg_data VARCHAR2(2000);

Line 81: pa_projects p

77: 'AT',task_number) formatted_message
78: FROM pa_cap_event_creation_v pe,
79: pa_lookups pl,
80: pa_lookups pl2,
81: pa_projects p
82: WHERE pe.request_id = x_conc_request_id
83: AND pl.lookup_type = 'PERIODIC_EVENT_CREATION'
84: AND pl.lookup_code = pe.message_code
85: AND pl2.lookup_type = 'CAPITAL_TYPE'

Line 235: FROM pa_projects p,

231:
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:

Line 370: FROM pa_projects_all

366: IF p_project_id IS NOT NULL THEN
367:
368: SELECT segment1
369: INTO v_project_number
370: FROM pa_projects_all
371: WHERE project_id = p_project_id;
372:
373:
374: INSERT INTO pa_cap_event_creation_v

Line 738: pa_projects p

734: c.capital_event_number,
735: c.event_name,
736: c.event_type
737: FROM pa_capital_events c,
738: pa_projects p
739: WHERE c.project_id = x_project_id
740: AND c.event_type = x_event_type
741: AND c.request_id = x_request_id
742: AND p.project_id = x_project_id

Line 759: pa_projects p

755: c.capital_event_number,
756: c.event_name,
757: c.event_type
758: FROM pa_capital_events c,
759: pa_projects p
760: WHERE c.project_id = p.project_id
761: AND c.project_id = x_project_id
762: AND c.event_period = p_event_period_name
763: AND c.event_type = x_event_type

Line 842: v_project_number pa_projects_all.segment1%TYPE;

838: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
840:
841: v_common_project VARCHAR2(1);
842: v_project_number pa_projects_all.segment1%TYPE;
843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;

Line 843: v_print_project_number pa_projects_all.segment1%TYPE;

839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
840:
841: v_common_project VARCHAR2(1);
842: v_project_number pa_projects_all.segment1%TYPE;
843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;
847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;