APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 811: FROM pa_project_assignments

807: AND pev.proj_element_id = pe.proj_element_id;
808:
809: CURSOR C_Named_Role(p_project_assignment_id IN NUMBER) IS
810: SELECT assignment_name, project_role_id
811: FROM pa_project_assignments
812: WHERE assignment_id = p_project_assignment_id;
813:
814: l_planning_resource_alias varchar2(240);
815: l_edit_task_ok VARCHAR2(1);

Line 2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2775: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2776: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2777: l_ta_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2778: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2912: pa_project_assignments asgn,

2908: FROM
2909: pa_copy_asgmts_temp temp,
2910: pa_proj_element_versions pev,
2911: pa_resource_assignments ra,
2912: pa_project_assignments asgn,
2913: pa_budget_lines bl,
2914: pa_resource_list_members rlm,
2915: pa_res_formats_b rf
2916: WHERE

Line 3005: pa_project_assignments asgn,

3001: FROM
3002: pa_copy_asgmts_temp temp,
3003: pa_proj_element_versions pev,
3004: pa_resource_assignments ra,
3005: pa_project_assignments asgn,
3006: pa_resource_list_members rlm,
3007: pa_res_formats_b rf
3008: WHERE
3009: pev.element_version_id = temp.src_elem_ver_id AND

Line 3068: pa_project_assignments asgn,

3064: FROM
3065: pa_copy_asgmts_temp temp,
3066: pa_proj_element_versions pev,
3067: pa_resource_assignments ra,
3068: pa_project_assignments asgn,
3069: pa_budget_lines bl,
3070: pa_resource_list_members source_rlm,
3071: pa_resource_list_members target_rlm,
3072: pa_res_formats_b rf

Line 3168: pa_project_assignments asgn,

3164: FROM
3165: pa_copy_asgmts_temp temp,
3166: pa_proj_element_versions pev,
3167: pa_resource_assignments ra,
3168: pa_project_assignments asgn,
3169: pa_resource_list_members source_rlm,
3170: pa_resource_list_members target_rlm,
3171: pa_res_formats_b rf
3172: WHERE

Line 5285: from pa_project_assignments pa,

5281: Cursor C_Role IS
5282:
5283: select distinct ro.meaning project_role
5284:
5285: from pa_project_assignments pa,
5286:
5287: pa_proj_roles_v ro
5288:
5289: where

Line 5385: from pa_project_assignments pap, pa_project_statuses stat

5381: Cursor C_Team_Role IS
5382:
5383: select distinct pap.assignment_name Team_Role, pap.assignment_effort
5384:
5385: from pa_project_assignments pap, pa_project_statuses stat
5386:
5387: where
5388:
5389: pap.resource_list_member_id = p_resource_list_member_id