APPS.PER_CAGR_UTILITY_PKG dependencies on PAY_INPUT_VALUES

Line 442: l_input_value_id pay_input_values.input_value_id%TYPE;

438: --
439: l_return_value per_cagr_entitlement_items.column_type%TYPE;
440: l_proc VARCHAR2(72) := g_pkg||'get_column_type';
441: l_item_category per_cagr_entitlement_items.category_name%TYPE;
442: l_input_value_id pay_input_values.input_value_id%TYPE;
443: l_uom per_cagr_entitlement_items.uom%TYPE;
444: l_column_type per_cagr_entitlement_items.column_type%TYPE;
445: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
446: --

Line 464: FROM pay_input_values_f piv

460: WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
461: --
462: CURSOR c_pay_item_type IS
463: SELECT piv.uom
464: FROM pay_input_values_f piv
465: WHERE piv.input_value_id = l_input_value_id
466: AND p_effective_date BETWEEN piv.effective_start_date
467: AND piv.effective_end_date;
468: --