[Home] [Help]
28: decode((decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID)
29: ),'TRUE',0,1)+ decode(decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id),hao.business_group_id,0,1)
30: + decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F', PAP.PERSON_ID, PAP.PERSON_TYPE_ID, PAP.EMPLOYEE_NUMBER,PAP.APPLICANT_NUMBER)
31: ),'TRUE',0,1) + decode(decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id),pap.business_group_id,0,1)),0,'Y','N') hasUpdateAccess
32: from hr_organization_information cm,per_all_people_f pap
33: ,hr_all_organization_units hao ,hr_all_organization_units_tl haotl
34: where cm.org_information_context = 'Organization Name Alias'
35: and cm.ORG_INFORMATION2 = p_id
36: and cm.ORG_INFORMATION2 = to_char(pap.person_id)
41: and trunc(sysdate) between hao.date_from and nvl(hao.date_to,trunc(sysdate))
42: and HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
43: and HAOTL.LANGUAGE = USERENV('LANG')
44: and trunc(sysdate) between hao.date_from and nvl(hao.date_to,trunc(sysdate))
45: and exists (select 'e' from hr_organization_information class,
46: hr_org_info_types_by_class ctype
47: where ctype.org_information_type = 'Organization Name Alias'
48: and ctype.org_classification = class.org_information1
49: and class.org_information_context = 'CLASS'
61: and (nvl(fnd_date.canonical_to_date(cm.ORG_INFORMATION4),sysdate) >= sysdate
62: Or (fnd_date.canonical_to_date(cm.ORG_INFORMATION4) <= sysdate
63: and fnd_date.canonical_to_date(cm.ORG_INFORMATION3)
64: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
65: from hr_organization_information oi
66: where oi.org_information_context = 'Organization Name Alias'
67: and oi.organization_id = cm.organization_id)));
68:
69: --