APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

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

1438: p_project_id IN NUMBER,
1439: p_wbs_version_id IN NUMBER,
1440: p_resource_list_member_id IN NUMBER ) IS
1441: Select a.alias, b.resource_assignment_id
1442: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
1443: where a.resource_list_member_id = b.resource_list_member_id
1444: and b.resource_list_member_id = p_resource_list_member_id
1445: and b.ta_display_flag = 'Y'
1446: and b.budget_version_id = bv.budget_version_id

Line 1456: from pa_resource_list_members

1452:
1453:
1454: CURSOR C_Res_List_mem_Check(p_resource_list_member_id IN NUMBER) IS
1455: SELECT 'X', resource_class_code
1456: from pa_resource_list_members
1457: where resource_list_member_id = p_resource_list_member_id;
1458: C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
1459:
1460: -- Bug 4087956

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

3753: p_project_id IN NUMBER,
3754: p_wbs_version_id IN NUMBER,
3755: p_resource_list_member_id IN NUMBER ) IS
3756: Select a.alias, b.resource_assignment_id
3757: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
3758: where a.resource_list_member_id = b.resource_list_member_id
3759: and b.resource_list_member_id = p_resource_list_member_id
3760: and b.ta_display_flag = 'Y'
3761: and b.budget_version_id = bv.budget_version_id

Line 3770: from pa_resource_list_members par

3766: c_rec_out c_cur_out%ROWTYPE;
3767:
3768: CURSOR C_Res_List_mem_Check(p_resource_list_member_id IN NUMBER) IS
3769: SELECT par.ALIAS, par.resource_class_code
3770: from pa_resource_list_members par
3771: where resource_list_member_id = p_resource_list_member_id;
3772: C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
3773:
3774: