APPS.PA_ASGMT_WFSTD dependencies on PA_RESOURCES_DENORM

Line 4877: -- Bug 5362698 - Get the name from HR instead of pa_resources_denorm so

4873: FROM pa_lookups plks
4874: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
4875: AND plks.lookup_code = p_override_basis_code;
4876:
4877: -- Bug 5362698 - Get the name from HR instead of pa_resources_denorm so
4878: -- that the latest name is obtained.
4879: /*
4880: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4881: SELECT res.resource_name,

Line 4883: FROM pa_resources_denorm res,

4879: /*
4880: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4881: SELECT res.resource_name,
4882: hr.name
4883: FROM pa_resources_denorm res,
4884: hr_all_organization_units hr
4885: WHERE res.resource_id = l_resource_id
4886: AND hr.organization_id = res.resource_organization_id
4887: AND l_start_date between resource_effective_start_date and resource_effective_end_date;

Line 4978: FROM pa_resources_denorm res

4974:
4975: --Getting recepients person_id
4976: SELECT res.person_id
4977: INTO l_ntfy_apprvl_rect_person_id
4978: FROM pa_resources_denorm res
4979: WHERE res.resource_id = l_resource_id
4980: AND rownum = 1;
4981:
4982: log_message('After getting person_id:' || l_ntfy_apprvl_rect_person_id);

Line 5534: pa_resources_denorm res,

5530: ppa.tp_percent_applied_override,
5531: ppa.work_type_name,
5532: hr.name
5533: FROM pa_project_assignments_v ppa,
5534: pa_resources_denorm res,
5535: hr_all_organization_units hr
5536: WHERE ppa.assignment_id = l_assignment_id
5537: AND res.resource_id = ppa.resource_id
5538: AND ppa.start_date BETWEEN res.resource_effective_start_date

Line 5942: FROM pa_resources_denorm res,

5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5939:
5940: CURSOR Resource_Manager IS
5941: SELECT distinct res.manager_id
5942: FROM pa_resources_denorm res,
5943: pa_project_assignments asgn,
5944: pa_wf_ntf_performers ntf,
5945: fnd_user fnd
5946: WHERE ntf.group_id = p_group_id

Line 5960: pa_resources_denorm res,

5956: SELECT distinct per.person_id as staffing_mgr_id
5957: FROM fnd_grants fg,
5958: fnd_objects fob,
5959: fnd_user fnd,
5960: pa_resources_denorm res,
5961: /* Commenting this for performance tuning Bug#2499051
5962: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5963: from dual) temp, */
5964: pa_project_assignments asgn,

Line 7338: pa_resources_denorm res,

7334: ppa.tp_percent_applied_override,
7335: ppa.work_type_name,
7336: hr.name
7337: FROM pa_project_assignments_v ppa,
7338: pa_resources_denorm res,
7339: hr_all_organization_units hr
7340: WHERE assignment_id = l_assignment_id
7341: AND res.resource_id = ppa.resource_id
7342: AND ppa.start_date BETWEEN res.resource_effective_start_date

Line 8073: l_resource_id pa_resources_denorm.resource_id%TYPE;

8069: l_error_item_type VARCHAR2(30);
8070: l_submitter_uname fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
8071: l_error_item_key NUMBER;
8072: l_submitter_user_id NUMBER;
8073: l_resource_id pa_resources_denorm.resource_id%TYPE;
8074: l_return_status VARCHAR2(1);
8075: l_group_id NUMBER;
8076: l_project_id NUMBER;
8077: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();