APPS.PER_CEI_BUS dependencies on PAY_INPUT_VALUES_F

Line 1255: FROM pay_input_values_f piv

1251: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
1252: --
1253: CURSOR csr_get_pay_default_uom IS
1254: SELECT piv.uom
1255: FROM pay_input_values_f piv
1256: WHERE piv.input_value_id = p_input_value_id
1257: AND p_effective_date BETWEEN piv.effective_start_date
1258: AND piv.effective_end_date;
1259: --

Line 1265: l_uom pay_input_values_f.uom%TYPE;

1261: --
1262: l_proc VARCHAR2(72) := g_package||'chk_uom';
1263: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
1264: l_default_uom per_cagr_api_parameters.default_uom%TYPE;
1265: l_uom pay_input_values_f.uom%TYPE;
1266: --
1267: BEGIN
1268: --
1269: hr_utility.set_location('Entering: '||l_proc,10);

Line 2103: l_dummy pay_input_values_f.input_value_id%TYPE;

2099: ,p_effective_date IN DATE
2100: ) IS
2101: --
2102: l_proc varchar2(72) := g_package || 'chk_input_value_id';
2103: l_dummy pay_input_values_f.input_value_id%TYPE;
2104: --
2105: CURSOR csr_chk_input_value IS
2106: SELECT piv.input_value_id
2107: FROM pay_input_values_f piv

Line 2107: FROM pay_input_values_f piv

2103: l_dummy pay_input_values_f.input_value_id%TYPE;
2104: --
2105: CURSOR csr_chk_input_value IS
2106: SELECT piv.input_value_id
2107: FROM pay_input_values_f piv
2108: WHERE piv.input_value_id = p_input_value_id
2109: AND piv.element_type_id = p_element_type_id
2110: AND p_effective_date BETWEEN piv.effective_start_date
2111: AND piv.effective_end_date;