APPS.PA_ASGMT_WFSTD dependencies on PA_RESOURCES_DENORM

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

4857: FROM pa_lookups plks
4858: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
4859: AND plks.lookup_code = p_override_basis_code;
4860:
4861: -- Bug 5362698 - Get the name from HR instead of pa_resources_denorm so
4862: -- that the latest name is obtained.
4863: /*
4864: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4865: SELECT res.resource_name,

Line 4867: FROM pa_resources_denorm res,

4863: /*
4864: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4865: SELECT res.resource_name,
4866: hr.name
4867: FROM pa_resources_denorm res,
4868: hr_all_organization_units hr
4869: WHERE res.resource_id = l_resource_id
4870: AND hr.organization_id = res.resource_organization_id
4871: AND l_start_date between resource_effective_start_date and resource_effective_end_date;

Line 4962: FROM pa_resources_denorm res

4958:
4959: --Getting recepients person_id
4960: SELECT res.person_id
4961: INTO l_ntfy_apprvl_rect_person_id
4962: FROM pa_resources_denorm res
4963: WHERE res.resource_id = l_resource_id
4964: AND rownum = 1;
4965:
4966: log_message('After getting person_id:' || l_ntfy_apprvl_rect_person_id);

Line 5518: pa_resources_denorm res,

5514: ppa.tp_percent_applied_override,
5515: ppa.work_type_name,
5516: hr.name
5517: FROM pa_project_assignments_v ppa,
5518: pa_resources_denorm res,
5519: hr_all_organization_units hr
5520: WHERE ppa.assignment_id = l_assignment_id
5521: AND res.resource_id = ppa.resource_id
5522: AND ppa.start_date BETWEEN res.resource_effective_start_date

Line 5926: FROM pa_resources_denorm res,

5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5923:
5924: CURSOR Resource_Manager IS
5925: SELECT distinct res.manager_id
5926: FROM pa_resources_denorm res,
5927: pa_project_assignments asgn,
5928: pa_wf_ntf_performers ntf,
5929: fnd_user fnd
5930: WHERE ntf.group_id = p_group_id

Line 5944: pa_resources_denorm res,

5940: SELECT distinct per.person_id as staffing_mgr_id
5941: FROM fnd_grants fg,
5942: fnd_objects fob,
5943: fnd_user fnd,
5944: pa_resources_denorm res,
5945: /* Commenting this for performance tuning Bug#2499051
5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5947: from dual) temp, */
5948: pa_project_assignments asgn,

Line 7322: pa_resources_denorm res,

7318: ppa.tp_percent_applied_override,
7319: ppa.work_type_name,
7320: hr.name
7321: FROM pa_project_assignments_v ppa,
7322: pa_resources_denorm res,
7323: hr_all_organization_units hr
7324: WHERE assignment_id = l_assignment_id
7325: AND res.resource_id = ppa.resource_id
7326: AND ppa.start_date BETWEEN res.resource_effective_start_date

Line 8057: l_resource_id pa_resources_denorm.resource_id%TYPE;

8053: l_error_item_type VARCHAR2(30);
8054: l_submitter_uname fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
8055: l_error_item_key NUMBER;
8056: l_submitter_user_id NUMBER;
8057: l_resource_id pa_resources_denorm.resource_id%TYPE;
8058: l_return_status VARCHAR2(1);
8059: l_group_id NUMBER;
8060: l_project_id NUMBER;
8061: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();