APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1460: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

1456: p_project_id IN NUMBER,
1457: p_wbs_version_id IN NUMBER,
1458: p_resource_list_member_id IN NUMBER ) IS
1459: Select a.alias, b.resource_assignment_id
1460: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
1461: where a.resource_list_member_id = b.resource_list_member_id
1462: and b.resource_list_member_id = p_resource_list_member_id
1463: and b.ta_display_flag = 'Y'
1464: and b.budget_version_id = bv.budget_version_id

Line 1477: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

1473: p_wbs_version_id IN NUMBER,
1474: p_resource_list_member_id IN NUMBER,
1475: p_cbs_element_id IN NUMBER ) IS
1476: Select a.alias, b.resource_assignment_id
1477: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
1478: where a.resource_list_member_id = b.resource_list_member_id
1479: and b.resource_list_member_id = p_resource_list_member_id
1480: and b.ta_display_flag = 'Y'
1481: and b.budget_version_id = bv.budget_version_id

Line 1492: from pa_resource_list_members

1488:
1489:
1490: CURSOR C_Res_List_mem_Check(p_resource_list_member_id IN NUMBER) IS
1491: SELECT 'X', resource_class_code
1492: from pa_resource_list_members
1493: where resource_list_member_id = p_resource_list_member_id;
1494: C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
1495:
1496: -- Bug 4087956

Line 4017: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

4013: p_project_id IN NUMBER,
4014: p_wbs_version_id IN NUMBER,
4015: p_resource_list_member_id IN NUMBER ) IS
4016: Select a.alias, b.resource_assignment_id
4017: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
4018: where a.resource_list_member_id = b.resource_list_member_id
4019: and b.resource_list_member_id = p_resource_list_member_id
4020: and b.ta_display_flag = 'Y'
4021: and b.budget_version_id = bv.budget_version_id

Line 4034: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

4030: p_wbs_version_id IN NUMBER,
4031: p_resource_list_member_id IN NUMBER,
4032: p_cbs_element_id IN NUMBER ) IS
4033: Select a.alias, b.resource_assignment_id
4034: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
4035: where a.resource_list_member_id = b.resource_list_member_id
4036: and b.resource_list_member_id = p_resource_list_member_id
4037: and b.ta_display_flag = 'Y'
4038: and b.budget_version_id = bv.budget_version_id

Line 4048: from pa_resource_list_members par

4044: c_rec_out_for_cbs c_cur_out_for_cbs%ROWTYPE;
4045:
4046: CURSOR C_Res_List_mem_Check(p_resource_list_member_id IN NUMBER) IS
4047: SELECT par.ALIAS, par.resource_class_code
4048: from pa_resource_list_members par
4049: where resource_list_member_id = p_resource_list_member_id;
4050: C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
4051:
4052: