APPS.PER_PCL_SHD dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 66: per_cagr_entitlement_items pci

62: SELECT pce.cagr_entitlement_item_id,
63: pci.category_name,
64: pce.formula_criteria
65: FROM per_cagr_entitlements pce,
66: per_cagr_entitlement_items pci
67: WHERE pci.cagr_entitlement_item_id = pce.cagr_entitlement_item_id
68: AND pce.cagr_entitlement_id = p_cagr_entitlement_id;
69: --
70: -- Declare Local Variables

Line 177: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

173: RETURN NUMBER IS
174: --
175: -- Declare Local Variables
176: --
177: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
178: l_proc VARCHAR2(72) := g_package || 'retrieve_value_set_id';
179: --
180: -- Cursor to fetch the entitlement_item_id
181: -- that entitlement_line is for.

Line 185: FROM per_cagr_entitlement_items cei

181: -- that entitlement_line is for.
182: --
183: CURSOR csr_get_value_set_id IS
184: SELECT flex_value_set_id
185: FROM per_cagr_entitlement_items cei
186: WHERE cei.cagr_entitlement_item_Id = P_cagr_entitlement_item_id
187: AND cei.flex_value_set_id IS NOT NULL;
188: --
189: BEGIN