DBA Data[Home] [Help]

APPS.PER_ABT_PKG dependencies on HR_LOOKUPS

Line 590: , hr_lookups lkp

586: select ipv.name
587: , ipv.uom
588: , ipv.input_value_id
589: from pay_input_values ipv
590: , hr_lookups lkp
591: where ipv.element_type_id = p_element_type_id
592: and ipv.uom = lkp.lookup_code
593: and lkp.lookup_type = 'UNITS'
594: and lkp.lookup_code in

Line 663: from hr_lookups

659: ,p_hours_or_days IN OUT varchar2) is
660: --
661: cursor c is
662: select lookup_code
663: from hr_lookups
664: where lookup_type = 'HOURS_OR_DAYS'
665: and lookup_code = 'H'
666: and p_value_uom in
667: ('H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3');