APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_BUDGET_VERSIONS

Line 1417: from pa_budget_versions

1413: l_scheduled_delay_tbl system.pa_num_tbl_type:= system.pa_num_tbl_type();
1414:
1415: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
1416: select budget_version_id
1417: from pa_budget_versions
1418: where project_structure_version_id = p_structure_version_id
1419: and project_id = p_pa_project_id;
1420:
1421:

Line 1442: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

1438: p_project_id IN NUMBER,
1439: p_wbs_version_id IN NUMBER,
1440: p_resource_list_member_id IN NUMBER ) IS
1441: Select a.alias, b.resource_assignment_id
1442: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
1443: where a.resource_list_member_id = b.resource_list_member_id
1444: and b.resource_list_member_id = p_resource_list_member_id
1445: and b.ta_display_flag = 'Y'
1446: and b.budget_version_id = bv.budget_version_id

Line 1464: from pa_resource_assignments a --, pa_budget_versions b

1460: -- Bug 4087956
1461: -- Cursor C_Reference_Check(p_res_assignment_reference IN VARCHAR2) IS
1462: Cursor C_Reference_Check(p_res_assignment_reference IN VARCHAR2, c_budget_version_id IN NUMBER) IS
1463: select 'X'
1464: from pa_resource_assignments a --, pa_budget_versions b
1465: where a.pm_res_assignment_reference = p_res_assignment_reference
1466: and a.pm_product_code = p_pm_product_code
1467: and a.project_id = p_pa_project_id
1468: and a.ta_display_flag is not null

Line 1481: from pa_resource_assignments b, pa_budget_versions bv

1477: p_project_id IN NUMBER,
1478: p_wbs_version_id IN NUMBER,
1479: p_resource_list_member_id IN NUMBER ) IS
1480: Select 'X'
1481: from pa_resource_assignments b, pa_budget_versions bv
1482: where b.resource_list_member_id = p_resource_list_member_id
1483: and b.ta_display_flag is not null
1484: and b.budget_version_id = bv.budget_version_id
1485: and b.project_id = bv.project_id

Line 1496: from pa_resource_assignments b, pa_budget_versions bv

1492: p_project_id IN NUMBER,
1493: p_wbs_version_id IN NUMBER
1494: ) IS
1495: Select b.budget_version_id
1496: from pa_resource_assignments b, pa_budget_versions bv
1497: where b.ta_display_flag = 'N'
1498: and b.budget_version_id = bv.budget_version_id
1499: and b.project_id = bv.project_id
1500: and bv.project_structure_version_id = p_structure_version_id

Line 2850: from pa_budget_versions

2846:
2847: -- Added for bug 5469303
2848: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
2849: select budget_version_id
2850: from pa_budget_versions
2851: where project_structure_version_id = p_structure_version_id
2852: and project_id = p_pa_project_id;
2853:
2854: l_budget_version_id number;

Line 3124: from pa_budget_versions

3120:
3121: -- Added for bug 5469303
3122: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
3123: select budget_version_id
3124: from pa_budget_versions
3125: where project_structure_version_id = p_structure_version_id
3126: and project_id = p_pa_project_id;
3127:
3128: l_budget_version_id number;

Line 3730: from pa_budget_versions

3726: WHERE resource_list_id = c_resource_list_id;
3727:
3728: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER) is
3729: select budget_version_id
3730: from pa_budget_versions
3731: where project_structure_version_id = p_structure_version_id
3732: and project_id = p_pa_project_id;
3733:
3734: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,

Line 3757: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

3753: p_project_id IN NUMBER,
3754: p_wbs_version_id IN NUMBER,
3755: p_resource_list_member_id IN NUMBER ) IS
3756: Select a.alias, b.resource_assignment_id
3757: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
3758: where a.resource_list_member_id = b.resource_list_member_id
3759: and b.resource_list_member_id = p_resource_list_member_id
3760: and b.ta_display_flag = 'Y'
3761: and b.budget_version_id = bv.budget_version_id

Line 3879: from pa_resource_assignments a, pa_budget_versions b

3875: -- Currently going ahead with commenting out the pm_product_code check.
3876:
3877: CURSOR c_ta_del(p_structure_version_id in number, p_project_id in number) is
3878: select a.resource_assignment_id, a.wbs_element_version_id
3879: from pa_resource_assignments a, pa_budget_versions b
3880: where a.budget_version_id = b.budget_version_id
3881: and a.project_id = b.project_id
3882: and a.ta_display_flag = 'Y'
3883: and b.project_id = p_project_id

Line 3897: from pa_resource_assignments a --, pa_budget_versions b

3893: -- Bug 4087956
3894: -- Cursor C_Reference_Check(p_res_assignment_reference IN VARCHAR2) IS
3895: Cursor C_Reference_Check(p_res_assignment_reference IN VARCHAR2, c_budget_version_id IN NUMBER) IS
3896: select 'X'
3897: from pa_resource_assignments a --, pa_budget_versions b
3898: where a.pm_res_assignment_reference = p_res_assignment_reference
3899: and a.pm_product_code = p_pm_product_code
3900: and a.project_id = p_pa_project_id
3901: and a.ta_display_flag is not null

Line 3914: from pa_resource_assignments b, pa_budget_versions bv

3910: p_project_id IN NUMBER,
3911: p_wbs_version_id IN NUMBER
3912: ) IS
3913: Select b.budget_version_id
3914: from pa_resource_assignments b, pa_budget_versions bv
3915: where b.ta_display_flag = 'N'
3916: and b.budget_version_id = bv.budget_version_id
3917: and b.project_id = bv.project_id
3918: and bv.project_structure_version_id = p_structure_version_id

Line 6329: FROM pa_resource_assignments a, pa_budget_versions b

6325:
6326: CURSOR l_task_asgmt_id_csr(l_struct_ver_id NUMBER)
6327: IS
6328: SELECT 'X'
6329: FROM pa_resource_assignments a, pa_budget_versions b
6330: WHERE a.resource_assignment_id = p_pa_task_assignment_id
6331: AND a.project_id = p_pa_project_id
6332: AND b.budget_version_id = a.budget_version_id
6333: AND b.project_structure_version_id = l_struct_ver_id;

Line 6338: FROM pa_resource_assignments a, pa_budget_versions b

6334:
6335:
6336: CURSOR c_task_asgmt_csr(p_struct_version_id IN NUMBER) IS
6337: SELECT a.resource_assignment_id
6338: FROM pa_resource_assignments a, pa_budget_versions b
6339: WHERE a.project_id = p_pa_project_id
6340: AND b.budget_version_id = a.budget_version_id
6341: AND b.project_structure_version_id = p_struct_version_id
6342: AND a.pm_res_assignment_reference = p_pm_task_asgmt_reference

Line 6347: FROM pa_resource_assignments a, pa_budget_versions b

6343: AND a.pm_product_code = p_pm_product_code;
6344:
6345: CURSOR c_task_asgmt_from_id_csr(p_struct_version_id IN NUMBER) IS
6346: SELECT a.resource_assignment_id
6347: FROM pa_resource_assignments a, pa_budget_versions b
6348: WHERE a.project_id = p_pa_project_id
6349: AND b.budget_version_id = a.budget_version_id
6350: AND b.project_structure_version_id = p_struct_version_id
6351: AND a.wbs_element_version_id = p_pa_task_elem_ver_id

Line 6380: pa_budget_versions bv,

6376: SELECT published_version.resource_assignment_id
6377: FROM pa_resource_assignments published_version,
6378: (SELECT task_id, resource_list_member_id
6379: FROM pa_resource_assignments ra,
6380: pa_budget_versions bv,
6381: pa_proj_elem_ver_structure pevs
6382: WHERE ra.pm_product_code = p_pm_product_code
6383: AND ra.pm_res_assignment_reference = p_pm_task_asgmt_reference
6384: AND ra.project_id = p_pa_project_id

Line 6390: pa_budget_versions bv

6386: AND bv.project_id = p_pa_project_id
6387: AND bv.project_structure_version_id = pevs.element_version_id
6388: AND pevs.current_flag = 'N'
6389: AND pevs.project_id = p_pa_project_id) working_version,
6390: pa_budget_versions bv
6391: WHERE working_version.task_id = published_version.task_id
6392: AND working_version.resource_list_member_id = published_version.resource_list_member_id
6393: AND bv.project_structure_version_id = l_structure_version_id
6394: AND published_version.project_id = p_pa_project_id