APPS.PA_TASK_PUB1 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 5399: FROM pa_resource_assignments

5395: --p1 bug 3888432
5396: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5397: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
5398: SELECT resource_assignment_id
5399: FROM pa_resource_assignments
5400: WHERE wbs_element_Version_id = c_task_ver_id
5401: AND ta_display_flag = 'N';
5402: l_assign_id NUMBER := NULL;
5403: BEGIN

Line 6714: FROM pa_resource_assignments

6710: --p1 bug 3888432
6711: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6712: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
6713: SELECT resource_assignment_id
6714: FROM pa_resource_assignments
6715: WHERE wbs_element_Version_id = c_task_ver_id
6716: AND ta_display_flag = 'N';
6717: l_assign_id NUMBER := NULL;
6718: BEGIN

Line 8642: FROM pa_resource_assignments

8638: --p1 bug 3888432
8639: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8640: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
8641: SELECT resource_assignment_id
8642: FROM pa_resource_assignments
8643: WHERE wbs_element_Version_id = c_task_ver_id
8644: AND ta_display_flag = 'N';
8645: l_assign_id NUMBER := NULL;
8646: BEGIN

Line 10834: FROM pa_resource_assignments

10830: --p1 bug 3888432
10831: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10832: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
10833: SELECT resource_assignment_id
10834: FROM pa_resource_assignments
10835: WHERE wbs_element_Version_id = c_task_ver_id
10836: AND ta_display_flag = 'N';
10837: l_assign_id NUMBER := NULL;
10838: BEGIN

Line 12507: FROM pa_resource_assignments

12503: --p1 bug 3888432
12504: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12505: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
12506: SELECT resource_assignment_id
12507: FROM pa_resource_assignments
12508: WHERE wbs_element_Version_id = c_task_ver_id
12509: AND ta_display_flag = 'N';
12510: l_assign_id NUMBER := NULL;
12511: BEGIN

Line 12671: FROM pa_resource_assignments

12667: WHERE element_version_id = c_structure_version_id;
12668:
12669: CURSOR planned_effort_exists(c_element_version_id IN NUMBER) IS
12670: SELECT 'Y'
12671: FROM pa_resource_assignments
12672: WHERE wbs_element_version_id = c_element_version_id
12673: AND total_plan_quantity > 0
12674: AND rownum = 1;
12675:

Line 17159: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra

17155: FROM pa_control_items pci, pa_ci_actions pcia
17156: WHERE pci.project_id = p_project_id
17157: AND pcia.ci_id = pci.ci_id
17158: AND pcia.ci_action_number = pci.open_action_num
17159: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra
17160: WHERE pbv.project_id = pci.project_Id
17161: AND pbv.ci_id = pci.ci_id
17162: AND pra.budget_version_id = pbv.budget_version_id
17163: AND pra.project_id = p_project_id