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 4235: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/

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

Line 5566: , pa_resource_list_members prlm

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

Line 6320: , pa_resource_list_members prlm

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

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

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

Line 6937: FROM pa_resource_list_members

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

Line 7004: , pa_resource_list_members prlm

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

Line 7066: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%type;

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