APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 877: FROM pa_project_assignments

873: AND pev.proj_element_id = pe.proj_element_id;
874:
875: CURSOR C_Named_Role(p_project_assignment_id IN NUMBER) IS
876: SELECT assignment_name, project_role_id
877: FROM pa_project_assignments
878: WHERE assignment_id = p_project_assignment_id;
879:
880: l_planning_resource_alias varchar2(240);
881: l_edit_task_ok VARCHAR2(1);

Line 2889: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2889: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2890: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2891: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2892: l_ta_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2893: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 3027: pa_project_assignments asgn,

3023: FROM
3024: pa_copy_asgmts_temp temp,
3025: pa_proj_element_versions pev,
3026: pa_resource_assignments ra,
3027: pa_project_assignments asgn,
3028: pa_budget_lines bl,
3029: pa_resource_list_members rlm,
3030: pa_res_formats_b rf
3031: WHERE

Line 3120: pa_project_assignments asgn,

3116: FROM
3117: pa_copy_asgmts_temp temp,
3118: pa_proj_element_versions pev,
3119: pa_resource_assignments ra,
3120: pa_project_assignments asgn,
3121: pa_resource_list_members rlm,
3122: pa_res_formats_b rf
3123: WHERE
3124: pev.element_version_id = temp.src_elem_ver_id AND

Line 3183: pa_project_assignments asgn,

3179: FROM
3180: pa_copy_asgmts_temp temp,
3181: pa_proj_element_versions pev,
3182: pa_resource_assignments ra,
3183: pa_project_assignments asgn,
3184: pa_budget_lines bl,
3185: pa_resource_list_members source_rlm,
3186: pa_resource_list_members target_rlm,
3187: pa_res_formats_b rf

Line 3283: pa_project_assignments asgn,

3279: FROM
3280: pa_copy_asgmts_temp temp,
3281: pa_proj_element_versions pev,
3282: pa_resource_assignments ra,
3283: pa_project_assignments asgn,
3284: pa_resource_list_members source_rlm,
3285: pa_resource_list_members target_rlm,
3286: pa_res_formats_b rf
3287: WHERE

Line 5401: from pa_project_assignments pa,

5397: Cursor C_Role IS
5398:
5399: select distinct ro.meaning project_role
5400:
5401: from pa_project_assignments pa,
5402:
5403: pa_proj_roles_v ro
5404:
5405: where

Line 5501: from pa_project_assignments pap, pa_project_statuses stat

5497: Cursor C_Team_Role IS
5498:
5499: select distinct pap.assignment_name Team_Role, pap.assignment_effort
5500:
5501: from pa_project_assignments pap, pa_project_statuses stat
5502:
5503: where
5504:
5505: pap.resource_list_member_id = p_resource_list_member_id