APPS.PAY_BLT_BUS dependencies on HR_LOOKUPS

Line 507: from hr_lookups hl

503:
504: Cursor c_chk_balance_uom
505: is
506: select '1'
507: from hr_lookups hl
508: where hl.lookup_type = 'UNITS' and
509: (hl.lookup_code in ('M','I','N','ND') or hl.lookup_code like 'H%') and
510: hl.enabled_flag = 'Y' and
511: hl.lookup_code = p_balance_uom and

Line 518: from hr_lookups hl

514:
515: Cursor c_chk_balance_uom_class(p_balance_uom_old varchar2)
516: is
517: select '1'
518: from hr_lookups hl
519: where hl.lookup_type = 'UNITS' and
520: hl.lookup_code = p_balance_uom and
521: substr(hl.lookup_code,1,1) = substr(p_balance_uom_old,1,1) and
522: hl.enabled_flag = 'Y' and