eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 29: FROM pa_resource_assignments ra, pa_resource_list_members pr

25: l_resource_aliases VARCHAR2(20000);
26:
27: CURSOR C1_GTR(p_element_version_id in NUMBER) IS
28: SELECT pr.alias
29: FROM pa_resource_assignments ra, pa_resource_list_members pr
30: WHERE ra.resource_list_member_id = pr.resource_list_member_id
31: AND ra.wbs_element_version_id = p_element_version_id
32: AND ra.resource_class_code = 'PEOPLE'
33: AND ra.ta_display_flag = 'Y'

Line 39: FROM pa_resource_assignments ra, pa_resource_list_members pr

35:
36: UNION ALL
37:
38: SELECT pr.alias
39: FROM pa_resource_assignments ra, pa_resource_list_members pr
40: WHERE ra.resource_list_member_id = pr.resource_list_member_id
41: AND ra.wbs_element_version_id = p_element_version_id
42: AND ra.resource_class_code = 'EQUIPMENT'
43: AND ra.ta_display_flag = 'Y'

Line 49: FROM pa_resource_assignments ra, pa_resource_list_members pr

45:
46: UNION ALL
47:
48: SELECT pr.alias
49: FROM pa_resource_assignments ra, pa_resource_list_members pr
50: WHERE ra.resource_list_member_id = pr.resource_list_member_id
51: AND ra.wbs_element_version_id = p_element_version_id
52: AND ra.resource_class_code = 'MATERIAL_ITEMS'
53: AND ra.ta_display_flag = 'Y'

Line 59: FROM pa_resource_assignments ra, pa_resource_list_members pr

55:
56: UNION ALL
57:
58: SELECT pr.alias
59: FROM pa_resource_assignments ra, pa_resource_list_members pr
60: WHERE ra.resource_list_member_id = pr.resource_list_member_id
61: AND ra.wbs_element_version_id = p_element_version_id
62: AND ra.resource_class_code = 'FINANCIAL_ELEMENTS'
63: AND ra.ta_display_flag = 'Y'

Line 2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%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();

Line 2914: pa_resource_list_members rlm,

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
2917: pev.element_version_id = temp.src_elem_ver_id AND
2918: pev.element_version_id = ra.wbs_element_version_id AND

Line 3006: pa_resource_list_members rlm,

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
3010: pev.element_version_id = ra.wbs_element_version_id AND

Line 3070: pa_resource_list_members source_rlm,

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
3073: WHERE
3074: pev.element_version_id = temp.src_elem_ver_id AND

Line 3071: pa_resource_list_members target_rlm,

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
3073: WHERE
3074: pev.element_version_id = temp.src_elem_ver_id AND
3075: pev.element_version_id = ra.wbs_element_version_id AND

Line 3169: pa_resource_list_members source_rlm,

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
3173: pev.element_version_id = temp.src_elem_ver_id AND

Line 3170: pa_resource_list_members target_rlm,

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
3173: pev.element_version_id = temp.src_elem_ver_id AND
3174: pev.element_version_id = ra.wbs_element_version_id AND

Line 4652: select par.alias, restype.name Res_type from pa_resource_list_members par,

4648:
4649:
4650: CURSOR C_pl_check(p_res_list_member_id IN NUMBER) IS
4651:
4652: select par.alias, restype.name Res_type from pa_resource_list_members par,
4653:
4654: pa_res_types_vl restype
4655:
4656: where par.fc_res_type_code = restype.RES_TYPE_CODE