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 138: FROM pa_resource_assignments ra, pa_resource_list_members pr

134: FUNCTION Get_Task_Resources(p_element_version_id IN NUMBER) RETURN VARCHAR2 IS
135:
136: CURSOR C1_GTR(p_element_version_id in NUMBER) IS
137: SELECT count(*) resource_count
138: FROM pa_resource_assignments ra, pa_resource_list_members pr
139: WHERE ra.resource_list_member_id = pr.resource_list_member_id
140: AND ra.wbs_element_version_id = p_element_version_id
141: AND ra.ta_display_flag = 'Y';
142:

Line 2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

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

Line 3029: pa_resource_list_members rlm,

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

Line 3121: pa_resource_list_members rlm,

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

Line 3185: pa_resource_list_members source_rlm,

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

Line 3186: pa_resource_list_members target_rlm,

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
3188: WHERE
3189: pev.element_version_id = temp.src_elem_ver_id AND
3190: pev.element_version_id = ra.wbs_element_version_id AND

Line 3284: pa_resource_list_members source_rlm,

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

Line 3285: pa_resource_list_members target_rlm,

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

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

4764:
4765:
4766: CURSOR C_pl_check(p_res_list_member_id IN NUMBER) IS
4767:
4768: select par.alias, restype.name Res_type from pa_resource_list_members par,
4769:
4770: pa_res_types_vl restype
4771:
4772: where par.fc_res_type_code = restype.RES_TYPE_CODE