APPS.GMS_BUDGET_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 450: from pa_resource_list_members

446:
447: cursor l_resource_list_member_id_csr(p_resource_list_member_id_in NUMBER)
448: IS
449: select 'X'
450: from pa_resource_list_members
451: where resource_list_member_id = p_resource_list_member_id_in;
452:
453: cursor l_reslist_member_alias_csr(p_resource_list_id_in NUMBER
454: , p_reslist_member_alias_in VARCHAR2)

Line 457: from pa_resource_list_members

453: cursor l_reslist_member_alias_csr(p_resource_list_id_in NUMBER
454: , p_reslist_member_alias_in VARCHAR2)
455: is
456: select resource_list_member_id
457: from pa_resource_list_members
458: where alias = p_reslist_member_alias_in
459: and resource_list_id = p_resource_list_id_in
460: and NVL(migration_code,'M') ='M'; -- Bug 3626671
461:

Line 895: x_resource_name pa_resource_list_members.alias%type; /*Modified for bug 4614242*/

891: x_top_task_id number;
892: x_budget_funding_level varchar2(1);
893: x_entry_level_code varchar2(1);
894: x_period_name varchar2(20);
895: x_resource_name pa_resource_list_members.alias%type; /*Modified for bug 4614242*/
896: x_project_number varchar2(25); -- Added for Bug:2269791
897: x_period_type varchar2(1);
898: x_categorization_code varchar2(30);
899:

Line 1080: from pa_resource_list_members

1076: end if;
1077:
1078: select alias
1079: into x_resource_name
1080: from pa_resource_list_members
1081: where resource_list_member_id = x_resource_List_Member_Id;
1082:
1083: -- Added for Bug: 2269791
1084: select segment1

Line 4236: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/

4232: l_attribute15 VARCHAR2(150);
4233: ---------------
4234: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
4235: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4236: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/
4237: l_function_allowed VARCHAR2(1);
4238: l_resp_id NUMBER := 0;
4239: l_user_id NUMBER := 0;
4240: l_login_id NUMBER := 0;

Line 5567: , pa_resource_list_members prlm

5563: CURSOR l_uncategorized_list_csr
5564: IS
5565: SELECT prlm.resource_list_member_id
5566: FROM pa_resource_lists prl
5567: , pa_resource_list_members prlm
5568: , pa_implementations pi
5569: WHERE prl.resource_list_id = prlm.resource_list_id
5570: AND prl.business_group_id = pi.business_group_id
5571: AND prl.uncategorized_flag='Y'

Line 6321: , pa_resource_list_members prlm

6317: CURSOR l_uncategorized_list_csr
6318: IS
6319: SELECT prlm.resource_list_member_id
6320: FROM pa_resource_lists prl
6321: , pa_resource_list_members prlm
6322: , pa_implementations pi
6323: WHERE prl.resource_list_id = prlm.resource_list_id
6324: AND prl.business_group_id = pi.business_group_id
6325: AND prl.uncategorized_flag='Y'

Line 6368: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/

6364: l_resource_assignment_id NUMBER;
6365: l_budget_start_date DATE;
6366: l_resource_list_id NUMBER;
6367: l_resource_list_member_id NUMBER;
6368: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/
6369: l_budget_amount_code VARCHAR2(30);
6370: l_entry_level_code VARCHAR2(30);
6371: l_categorization_code VARCHAR2(30);
6372: l_resp_id NUMBER := 0;

Line 6938: FROM pa_resource_list_members

6934: (p_resource_list_member_id NUMBER
6935: ,p_resource_list_id NUMBER)
6936: IS
6937: SELECT 'X'
6938: FROM pa_resource_list_members
6939: WHERE resource_list_id = p_resource_list_id
6940: AND resource_list_member_id = p_resource_list_member_id;
6941:
6942: -- needed to get the fields associated to a budget entry method

Line 7005: , pa_resource_list_members prlm

7001: CURSOR l_uncat_list_member_csr
7002: IS
7003: SELECT prlm.resource_list_member_id
7004: FROM pa_resource_lists prl
7005: , pa_resource_list_members prlm
7006: , pa_implementations pi
7007: WHERE prl.resource_list_id = prlm.resource_list_id
7008: AND prl.business_group_id = pi.business_group_id
7009: AND prl.uncategorized_flag='Y'

Line 7067: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%type;

7063: l_raw_cost NUMBER;
7064: l_burdened_cost NUMBER;
7065: l_quantity NUMBER;
7066: l_unit_of_measure pa_resources.unit_of_measure%type;
7067: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%type;
7068: l_resource_assignment_id gms_resource_assignments.resource_assignment_id%type;
7069: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
7070: l_wbs_level NUMBER;
7071: l_return_status_task NUMBER;