APPS.PA_BURDEN_COSTING dependencies on PA_PROJECT_TYPES_ALL

Line 257: pa_project_types_all pt -- pa_project_types_all changed to pa_project_types for Bug# 5743708 /*pa_project_types is changed to pa_project_types_all for the bug 6610145*/

253: , pt.burden_sum_dest_project_id dest_project_id
254: , pt.burden_sum_dest_task_id dest_task_id
255: , upper(pt.burden_amt_display_method) burden_amt_display_method
256: from pa_projects_all p, -- pa_projects_all changed to pa_projects for Bug# 5743708 /*pa_projects is changed to pa_projects_all for the bug 6610145*/
257: pa_project_types_all pt -- pa_project_types_all changed to pa_project_types for Bug# 5743708 /*pa_project_types is changed to pa_project_types_all for the bug 6610145*/
258: where pt.project_type = p.project_type
259: and p.segment1 between p_start_project_number and p_end_project_number /*2255068*/
260: and ( pt.burden_amt_display_method in ('D','d') or
261: pt.burden_amt_display_method in ('S','s') and

Line 306: pa_project_types_all pt -- Bug # 5743708 changing pa_project_typees_all to pa_project_types /*changed pa_project_types to pa_project_types_all for the bug 6610145 */

302: , pt.burden_sum_dest_project_id dest_project_id
303: , pt.burden_sum_dest_task_id dest_task_id
304: , upper(pt.burden_amt_display_method) burden_amt_display_method
305: from pa_projects_all p, -- Bug # 5743708 changing pa_projects_all to pa_projects /*changed pa_projects to pa_projects_all for the bug 6610145 */
306: pa_project_types_all pt -- Bug # 5743708 changing pa_project_typees_all to pa_project_types /*changed pa_project_types to pa_project_types_all for the bug 6610145 */
307: where pt.project_type = p.project_type
308: and p.segment1 between p_start_project_number and p_end_project_number /*2255068*/
309: and ( pt.burden_amt_display_method in ('D','d') or
310: pt.burden_amt_display_method in ('S','s') and

Line 2649: * pa_project_types_all instead of pa_projects, pa_project_types.

2645: -- Bug 2838499: Used pa_projects Org view instead of table.
2646: -- added org_id join between pt and p.
2647: /*
2648: * Bug 4914022 : Changed projects cursor to join to pa_projects_all
2649: * pa_project_types_all instead of pa_projects, pa_project_types.
2650: */
2651: Cursor projects is
2652: select /*+ use_hash(pt p) */
2653: p.project_id , p.segment1

Line 2657: pa_project_types_all pt

2653: p.project_id , p.segment1
2654: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
2655: , upper(pt.burden_amt_display_method) burden_amt_display_method
2656: from pa_projects_all p,
2657: pa_project_types_all pt
2658: where pt.project_type = p.project_type
2659: and pt.org_id = p.org_id /*5368274*/
2660: and pt.burden_amt_display_method in ('D','d')
2661: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */