DBA Data[Home] [Help]

APPS.PER_ABT_PKG dependencies on PAY_INPUT_VALUES

Line 589: from pay_input_values ipv

585: cursor c is
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'

Line 714: from pay_input_values

710: ,p_input_value_id NUMBER) is
711: --
712: cursor c is
713: select ''
714: from pay_input_values
715: where element_type_id = p_element_type_id
716: and input_value_id <> p_input_value_id
717: and ((hot_default_flag = 'N'
718: and mandatory_flag = 'Y')