APPS.PQP_GB_OMP_TEMPLATE dependencies on HR_LOOKUPS

Line 215: FROM hr_lookups hrl

211: AND balance_name = c_bal_name;
212:
213: CURSOR c_get_band_meaning (c_effective_date DATE) IS
214: SELECT meaning
215: FROM hr_lookups hrl
216: WHERE lookup_type = 'PQP_GAP_ENTITLEMENT_BANDS'
217: AND NVL(enabled_flag,'Y') = 'Y'
218: AND lookup_code like 'BAND%'
219: AND c_effective_date BETWEEN hrl.start_date_active