APPS.PA_TASK_PUB1 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 5124: FROM pa_resource_assignments

5120: --p1 bug 3888432
5121: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5122: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
5123: SELECT resource_assignment_id
5124: FROM pa_resource_assignments
5125: WHERE wbs_element_Version_id = c_task_ver_id
5126: AND ta_display_flag = 'N';
5127: l_assign_id NUMBER := NULL;
5128: BEGIN

Line 6432: FROM pa_resource_assignments

6428: --p1 bug 3888432
6429: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6430: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
6431: SELECT resource_assignment_id
6432: FROM pa_resource_assignments
6433: WHERE wbs_element_Version_id = c_task_ver_id
6434: AND ta_display_flag = 'N';
6435: l_assign_id NUMBER := NULL;
6436: BEGIN

Line 8279: FROM pa_resource_assignments

8275: --p1 bug 3888432
8276: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8277: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
8278: SELECT resource_assignment_id
8279: FROM pa_resource_assignments
8280: WHERE wbs_element_Version_id = c_task_ver_id
8281: AND ta_display_flag = 'N';
8282: l_assign_id NUMBER := NULL;
8283: BEGIN

Line 10454: FROM pa_resource_assignments

10450: --p1 bug 3888432
10451: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10452: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
10453: SELECT resource_assignment_id
10454: FROM pa_resource_assignments
10455: WHERE wbs_element_Version_id = c_task_ver_id
10456: AND ta_display_flag = 'N';
10457: l_assign_id NUMBER := NULL;
10458: BEGIN

Line 12091: FROM pa_resource_assignments

12087: --p1 bug 3888432
12088: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12089: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
12090: SELECT resource_assignment_id
12091: FROM pa_resource_assignments
12092: WHERE wbs_element_Version_id = c_task_ver_id
12093: AND ta_display_flag = 'N';
12094: l_assign_id NUMBER := NULL;
12095: BEGIN