DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on HR_LOOKUPS

Line 71: FROM hr_lookups --fnd_common_lookups

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

Line 72: -- changed to hr_lookups for bug 3780751

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 ;