APPS.PER_CAGR_UTILITY_PKG dependencies on PER_CAGR_API_PARAMETERS

Line 445: l_uom_lookup per_cagr_api_parameters.uom_lookup%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: --
447: CURSOR csr_get_uom_details IS
448: SELECT cei.uom,
449: cei.column_type,

Line 452: per_cagr_api_parameters p

448: SELECT cei.uom,
449: cei.column_type,
450: p.uom_lookup
451: FROM per_cagr_entitlement_items cei,
452: per_cagr_api_parameters p
453: WHERE cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
454: AND p.cagr_api_param_id (+) = cei.cagr_api_param_id;
455: --
456: CURSOR c_item_category IS