APPS.PAY_BLT_BUS dependencies on HR_LOOKUPS

Line 479: from hr_lookups hl

475:
476: Cursor c_chk_balance_uom
477: is
478: select '1'
479: from hr_lookups hl
480: where hl.lookup_type = 'UNITS' and
481: (hl.lookup_code in ('M','I','N','ND') or hl.lookup_code like 'H%') and
482: hl.enabled_flag = 'Y' and
483: hl.lookup_code = p_balance_uom and

Line 490: from hr_lookups hl

486:
487: Cursor c_chk_balance_uom_class(p_balance_uom_old varchar2)
488: is
489: select '1'
490: from hr_lookups hl
491: where hl.lookup_type = 'UNITS' and
492: hl.lookup_code = p_balance_uom and
493: substr(hl.lookup_code,1,1) = substr(p_balance_uom_old,1,1) and
494: hl.enabled_flag = 'Y' and