67: AND ( pgda.level_of_entitlement <> 'NOT'
68: AND pgda.level_of_entitlement <> 'NOBAND'
69: AND pgda.level_of_entitlement NOT IN
70: ( SELECT lookup_code
71: FROM hr_lookups --fnd_common_lookups
72: -- changed to hr_lookups for bug 3780751
73: WHERE lookup_type = p_lookup_type )
74: )
75: GROUP BY level_of_entitlement
68: AND pgda.level_of_entitlement <> 'NOBAND'
69: AND pgda.level_of_entitlement NOT IN
70: ( SELECT lookup_code
71: FROM hr_lookups --fnd_common_lookups
72: -- changed to hr_lookups for bug 3780751
73: WHERE lookup_type = p_lookup_type )
74: )
75: GROUP BY level_of_entitlement
76: ORDER BY level_of_entitlement ;