APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECTS_ALL

Line 2236: FROM pa_projects_all

2232:
2233: IF (p_sch_except_record.change_calendar_type_code = 'PROJECT') THEN
2234: SELECT calendar_id
2235: INTO l_t_calendar_id
2236: FROM pa_projects_all
2237: WHERE project_id = p_sch_except_record.project_id;
2238:
2239: -- Use change_calendar_id passed from calendar LOV for the calendar_id to be updated
2240: ELSIF (p_sch_except_record.change_calendar_type_code = 'OTHER') THEN

Line 5426: FROM pa_projects_all prj,

5422: WHERE assignment_id = p_assignment_id;
5423:
5424: CURSOR get_project_calendar_id IS
5425: SELECT prj.calendar_id
5426: FROM pa_projects_all prj,
5427: pa_project_assignments asmt
5428: WHERE asmt.assignment_id = p_assignment_id
5429: AND prj.project_id = asmt.project_id;
5430:

Line 7036: Rremoved some columns and modified table from pa_projects_list_v to pa_projects_all,

7032:
7033: -- Retriev the source project info.
7034:
7035: /* Commented this cursor for bug 3115273 and added new one below.
7036: Rremoved some columns and modified table from pa_projects_list_v to pa_projects_all,
7037: Also removed distinct and added rownum = 1
7038:
7039: CURSOR c1 IS
7040: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1, proj.person_name, proj.carrying_out_organization_name, proj.customer_name

Line 7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7048: /* Cursor added for bug 3115273 */
7049:
7050: CURSOR c1 IS
7051: SELECT asgn.project_id, proj.name, proj.segment1, proj.carrying_out_organization_id
7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7053: WHERE asgn.assignment_id = hist.assignment_id
7054: AND hist.conflict_group_id = p_conflict_group_id
7055: AND asgn.project_id = proj.project_id
7056: AND ROWNUM = 1;

Line 7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7059:
7060: -- Retrieve conflict projects info.
7061: CURSOR c2 IS
7062: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1
7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7064: WHERE asgn.assignment_id = hist.conflict_assignment_id
7065: AND hist.conflict_group_id = p_conflict_group_id
7066: AND asgn.project_id = proj.project_id
7067: AND hist.self_conflict_flag = 'N';

Line 7096: l_source_proj_name pa_projects_all.name%TYPE;

7092:
7093: l_item_type pa_wf_processes.item_type%TYPE;
7094: l_item_key pa_wf_processes.item_key%TYPE;
7095: l_source_proj_id NUMBER;
7096: l_source_proj_name pa_projects_all.name%TYPE;
7097: l_source_proj_number pa_projects_all.segment1%TYPE;
7098: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */
7099: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */
7100: l_source_proj_customer pa_customers_v.customer_name%type; /* Bug 3115273 pa_project_lists_v.customer_name%TYPE; */

Line 7097: l_source_proj_number pa_projects_all.segment1%TYPE;

7093: l_item_type pa_wf_processes.item_type%TYPE;
7094: l_item_key pa_wf_processes.item_key%TYPE;
7095: l_source_proj_id NUMBER;
7096: l_source_proj_name pa_projects_all.name%TYPE;
7097: l_source_proj_number pa_projects_all.segment1%TYPE;
7098: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */
7099: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */
7100: l_source_proj_customer pa_customers_v.customer_name%type; /* Bug 3115273 pa_project_lists_v.customer_name%TYPE; */
7101: l_conflict_proj_id NUMBER;

Line 7796: -- pa_projects_all b, -- Bug 5086869

7792: CURSOR C1 IS
7793: SELECT a.start_date, a.end_date, NVL(a.quantity,0),
7794: c.planning_start_date, c.planning_end_date -- 4367912
7795: FROM pa_budget_lines a,
7796: -- pa_projects_all b, -- Bug 5086869
7797: pa_resource_assignments c
7798: WHERE a.resource_assignment_id = c.resource_assignment_id
7799: AND c.resource_assignment_id = l_task_assignment_id;
7800: -- Bug 5086869 - In WP, there is only one currency