APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PA_PROJECTS_ALL

Line 2760: -- their base table pa_projects_all and pa_tasks are used instead.

2756:
2757: ----------------------------------------------------------------------
2758: -- MOAC Changes for R12:
2759: -- References to PJM_PROJECTS_V and PJM_TASKS_V has been removed and
2760: -- their base table pa_projects_all and pa_tasks are used instead.
2761: ----------------------------------------------------------------------
2762:
2763: BEGIN
2764: l_stmt_num := 45;

Line 2770: FROM pa_projects_all ppa

2766: SELECT ppa.org_id,
2767: ppa.segment1 -- project number
2768: INTO l_proj_org_id,
2769: l_project_number
2770: FROM pa_projects_all ppa
2771: WHERE ppa.project_id = p_project_id;
2772: /* l_stmt_num := 50;
2773: SELECT segment1 -- project number
2774: INTO l_project_number

Line 2775: FROM pa_projects_all

2771: WHERE ppa.project_id = p_project_id;
2772: /* l_stmt_num := 50;
2773: SELECT segment1 -- project number
2774: INTO l_project_number
2775: FROM pa_projects_all
2776: WHERE project_id = p_project_id; */
2777: l_stmt_num := 55;
2778: SELECT task_number
2779: INTO l_task_number

Line 2792: FROM pa_projects_all ppa

2788: SELECT ppa.org_id,
2789: ppa.segment1 -- project number
2790: INTO l_to_proj_org_id,
2791: l_to_project_number
2792: FROM pa_projects_all ppa
2793: WHERE ppa.project_id = p_to_project_id;
2794: /* l_stmt_num := 65;
2795: SELECT segment1 -- project number
2796: INTO l_to_project_number

Line 2797: FROM pa_projects_all

2793: WHERE ppa.project_id = p_to_project_id;
2794: /* l_stmt_num := 65;
2795: SELECT segment1 -- project number
2796: INTO l_to_project_number
2797: FROM pa_projects_all
2798: WHERE project_id = p_to_project_id; */
2799: l_stmt_num := 70;
2800: SELECT task_number
2801: INTO l_to_task_number

Line 2813: FROM pa_projects_all ppa

2809: SELECT ppa.org_id,
2810: segment1
2811: INTO l_source_proj_org_id,
2812: l_source_project_number
2813: FROM pa_projects_all ppa
2814: WHERE ppa.project_id = p_source_project_id;
2815: /* l_stmt_num := 80;
2816: SELECT segment1 -- project number
2817: INTO l_source_project_number

Line 2818: FROM pa_projects_all

2814: WHERE ppa.project_id = p_source_project_id;
2815: /* l_stmt_num := 80;
2816: SELECT segment1 -- project number
2817: INTO l_source_project_number
2818: FROM pa_projects_all
2819: WHERE project_id = p_source_project_id; */
2820: l_stmt_num := 85;
2821: SELECT task_number
2822: INTO l_source_task_number

Line 5705: -- their base table pa_projects_all and pa_tasks are used instead.

5701:
5702: ----------------------------------------------------------------------
5703: -- MOAC Changes for R12:
5704: -- References to PJM_PROJECTS_V and PJM_TASKS_V has been removed and
5705: -- their base table pa_projects_all and pa_tasks are used instead.
5706: ----------------------------------------------------------------------
5707:
5708: BEGIN
5709: l_stmt_num := 35;

Line 5713: FROM pa_projects_all

5709: l_stmt_num := 35;
5710: IF p_project_id is NOT NULL then
5711: SELECT segment1 -- project number
5712: INTO l_project_number
5713: FROM pa_projects_all
5714: WHERE project_id = p_project_id;
5715:
5716: l_stmt_num := 36;
5717: