APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECTS_ALL

Line 2431: FROM pa_projects_all

2427:
2428: IF (p_sch_except_record.change_calendar_type_code = 'PROJECT') THEN
2429: SELECT calendar_id
2430: INTO l_t_calendar_id
2431: FROM pa_projects_all
2432: WHERE project_id = p_sch_except_record.project_id;
2433:
2434: -- Use change_calendar_id passed from calendar LOV for the calendar_id to be updated
2435: ELSIF (p_sch_except_record.change_calendar_type_code = 'OTHER') THEN

Line 5714: FROM pa_projects_all prj,

5710: WHERE assignment_id = p_assignment_id;
5711:
5712: CURSOR get_project_calendar_id IS
5713: SELECT prj.calendar_id
5714: FROM pa_projects_all prj,
5715: pa_project_assignments asmt
5716: WHERE asmt.assignment_id = p_assignment_id
5717: AND prj.project_id = asmt.project_id;
5718:

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

7325:
7326: -- Retriev the source project info.
7327:
7328: /* Commented this cursor for bug 3115273 and added new one below.
7329: Rremoved some columns and modified table from pa_projects_list_v to pa_projects_all,
7330: Also removed distinct and added rownum = 1
7331:
7332: CURSOR c1 IS
7333: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1, proj.person_name, proj.carrying_out_organization_name, proj.customer_name

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

7341: /* Cursor added for bug 3115273 */
7342:
7343: CURSOR c1 IS
7344: SELECT asgn.project_id, proj.name, proj.segment1, proj.carrying_out_organization_id
7345: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7346: WHERE asgn.assignment_id = hist.assignment_id
7347: AND hist.conflict_group_id = p_conflict_group_id
7348: AND asgn.project_id = proj.project_id
7349: AND ROWNUM = 1;

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

7352:
7353: -- Retrieve conflict projects info.
7354: CURSOR c2 IS
7355: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1
7356: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7357: WHERE asgn.assignment_id = hist.conflict_assignment_id
7358: AND hist.conflict_group_id = p_conflict_group_id
7359: AND asgn.project_id = proj.project_id
7360: AND hist.self_conflict_flag = 'N';

Line 7389: l_source_proj_name pa_projects_all.name%TYPE;

7385:
7386: l_item_type pa_wf_processes.item_type%TYPE;
7387: l_item_key pa_wf_processes.item_key%TYPE;
7388: l_source_proj_id NUMBER;
7389: l_source_proj_name pa_projects_all.name%TYPE;
7390: l_source_proj_number pa_projects_all.segment1%TYPE;
7391: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */
7392: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */
7393: l_source_proj_customer pa_customers_v.customer_name%type; /* Bug 3115273 pa_project_lists_v.customer_name%TYPE; */

Line 7390: l_source_proj_number pa_projects_all.segment1%TYPE;

7386: l_item_type pa_wf_processes.item_type%TYPE;
7387: l_item_key pa_wf_processes.item_key%TYPE;
7388: l_source_proj_id NUMBER;
7389: l_source_proj_name pa_projects_all.name%TYPE;
7390: l_source_proj_number pa_projects_all.segment1%TYPE;
7391: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */
7392: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */
7393: l_source_proj_customer pa_customers_v.customer_name%type; /* Bug 3115273 pa_project_lists_v.customer_name%TYPE; */
7394: l_conflict_proj_id NUMBER;

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

8085: CURSOR C1 IS
8086: SELECT a.start_date, a.end_date, NVL(a.quantity,0),
8087: c.planning_start_date, c.planning_end_date -- 4367912
8088: FROM pa_budget_lines a,
8089: -- pa_projects_all b, -- Bug 5086869
8090: pa_resource_assignments c
8091: WHERE a.resource_assignment_id = c.resource_assignment_id
8092: AND c.resource_assignment_id = l_task_assignment_id;
8093: -- Bug 5086869 - In WP, there is only one currency