APPS.HR_SUPERVISOR_SS dependencies on HR_SECURITY

Line 90: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'

86: SELECT hao.organization_id
87: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
88: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
89: ,decode(
90: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
91: ,HR_SECURITY.SHOW_RECORD
92: ('HR_ALL_ORGANIZATION_UNITS'
93: ,HAO.ORGANIZATION_ID
94: )

Line 91: ,HR_SECURITY.SHOW_RECORD

87: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
88: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
89: ,decode(
90: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
91: ,HR_SECURITY.SHOW_RECORD
92: ('HR_ALL_ORGANIZATION_UNITS'
93: ,HAO.ORGANIZATION_ID
94: )
95: ),'TRUE',0,1

Line 103: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'

99: ,hr_general.get_business_group_id
100: )
101: ,hao.business_group_id,0,1
102: ) +
103: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
104: ,HR_SECURITY.SHOW_RECORD
105: ('PER_ALL_PEOPLE_F'
106: ,PAP.PERSON_ID
107: ,PAP.PERSON_TYPE_ID

Line 104: ,HR_SECURITY.SHOW_RECORD

100: )
101: ,hao.business_group_id,0,1
102: ) +
103: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
104: ,HR_SECURITY.SHOW_RECORD
105: ('PER_ALL_PEOPLE_F'
106: ,PAP.PERSON_ID
107: ,PAP.PERSON_TYPE_ID
108: ,PAP.EMPLOYEE_NUMBER