APPS.HR_SUPERVISOR_SS dependencies on HR_SECURITY

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

81: SELECT hao.organization_id
82: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
83: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
84: ,decode(
85: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
86: ,HR_SECURITY.SHOW_RECORD
87: ('HR_ALL_ORGANIZATION_UNITS'
88: ,HAO.ORGANIZATION_ID
89: )

Line 86: ,HR_SECURITY.SHOW_RECORD

82: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
83: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
84: ,decode(
85: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
86: ,HR_SECURITY.SHOW_RECORD
87: ('HR_ALL_ORGANIZATION_UNITS'
88: ,HAO.ORGANIZATION_ID
89: )
90: ),'TRUE',0,1

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

94: ,hr_general.get_business_group_id
95: )
96: ,hao.business_group_id,0,1
97: ) +
98: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
99: ,HR_SECURITY.SHOW_RECORD
100: ('PER_ALL_PEOPLE_F'
101: ,PAP.PERSON_ID
102: ,PAP.PERSON_TYPE_ID

Line 99: ,HR_SECURITY.SHOW_RECORD

95: )
96: ,hao.business_group_id,0,1
97: ) +
98: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
99: ,HR_SECURITY.SHOW_RECORD
100: ('PER_ALL_PEOPLE_F'
101: ,PAP.PERSON_ID
102: ,PAP.PERSON_TYPE_ID
103: ,PAP.EMPLOYEE_NUMBER