APPS.PER_PCL_SHD dependencies on PER_CAGR_ENTITLEMENTS

Line 65: FROM per_cagr_entitlements pce,

61: CURSOR csr_get_entitlement_item_id IS
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: --

Line 127: FROM per_cagr_entitlements pce,

123: --
124: CURSOR csr_cagr_info IS
125: SELECT cag.collective_agreement_id,
126: cag.business_group_id
127: FROM per_cagr_entitlements pce,
128: per_collective_agreements cag
129: WHERE cag.collective_agreement_id = pce.collective_agreement_id
130: AND pce.cagr_entitlement_id = p_cagr_entitlement_id;
131: --

Line 172: (p_cagr_entitlement_item_id IN per_cagr_entitlements.cagr_entitlement_item_id%TYPE)

168: -- |-------------------------< retrieve_value_set_id >------------------------|
169: -- ----------------------------------------------------------------------------
170: --
171: FUNCTION retrieve_value_set_id
172: (p_cagr_entitlement_item_id IN per_cagr_entitlements.cagr_entitlement_item_id%TYPE)
173: RETURN NUMBER IS
174: --
175: -- Declare Local Variables
176: --