DBA Data[Home] [Help]

APPS.PAY_ADHOC_UTILS_PKG dependencies on HR_BIS

Line 22: hr_bis.bis_decode_lookup('PROCESSING_TYPE',pet.PROCESSING_TYPE) Recurring,

18: SELECT pivtl.name Name,
19: peev.screen_entry_value value ,
20: piv.lookup_type lookup_type,
21: piv.value_set_id ,
22: hr_bis.bis_decode_lookup('PROCESSING_TYPE',pet.PROCESSING_TYPE) Recurring,
23: pettl.element_name element_name,
24: pectl.classification_name classification
25: FROM pay_element_entries_f pee,
26: pay_element_types_f pet,

Line 81: g_input_name_value_tab(v_index).v_input_value := hr_bis.bis_decode_lookup

77: --
78: g_input_name_value_tab(v_index).v_input_name := v_input_name_value.name;
79: --
80: IF v_input_name_value.lookup_type IS NOT NULL THEN
81: g_input_name_value_tab(v_index).v_input_value := hr_bis.bis_decode_lookup
82: (v_input_name_value.lookup_type,v_input_name_value.value);
83: --
84: ELSIF v_input_name_value.value_set_id IS NOT NULL THEN
85: g_input_name_value_tab(v_index).v_input_value := pay_input_values_pkg.decode_vset_value

Line 218: l_active := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'A');

214: --
215: BEGIN
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: l_active := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'A');
219: l_inactive := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'I');
220:
221: -- If status is null, both active and inactive records are displayed.
222: -- If the status is active then only active records as of the effective dates are displayed.

Line 219: l_inactive := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'I');

215: BEGIN
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: l_active := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'A');
219: l_inactive := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'I');
220:
221: -- If status is null, both active and inactive records are displayed.
222: -- If the status is active then only active records as of the effective dates are displayed.
223: -- If the status is inactive then only inactive records as of the effective dates are displayed.

Line 822: (pba.legislation_code = hr_bis.get_legislation_code and pba.business_group_id is null));

818: WHERE pba.attribute_id = pbad.attribute_id
819: AND pba.defined_balance_id = c_defined_balance_id
820: AND pbad.attribute_name = c_attribute_name
821: AND ((pba.business_group_id = c_business_group_id and pba.legislation_code is null) or
822: (pba.legislation_code = hr_bis.get_legislation_code and pba.business_group_id is null));
823:
824: v_balance_exists VARCHAR2(1);
825: v_defined_balance_id NUMBER;
826: