APPS.HR_CCMGR_SS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 33: ,hr_all_organization_units hao ,hr_all_organization_units_tl haotl

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)
37: and pap.current_employee_flag = 'Y'