APPS.HR_CAGR_ENT_ITEM_API dependencies on BEN_OPT_F

Line 47: l_opt_id ben_opt_f.opt_id%TYPE;

43: l_language_code hr_locations_all_tl.language%TYPE;
44: --
45: -- Declare variables for Option API Call
46: --
47: l_opt_id ben_opt_f.opt_id%TYPE;
48: l_opt_ovn ben_opt_f.object_version_number%TYPE;
49: l_effective_start_date DATE;
50: l_effective_end_date DATE;
51: --

Line 48: l_opt_ovn ben_opt_f.object_version_number%TYPE;

44: --
45: -- Declare variables for Option API Call
46: --
47: l_opt_id ben_opt_f.opt_id%TYPE;
48: l_opt_ovn ben_opt_f.object_version_number%TYPE;
49: l_effective_start_date DATE;
50: l_effective_end_date DATE;
51: --
52: CURSOR csr_get_api_id IS

Line 525: FROM ben_opt_f b,

521: --
522: CURSOR csr_option IS
523: SELECT b.opt_id,
524: b.object_version_number
525: FROM ben_opt_f b,
526: PER_CAGR_ENTITLEMENT_ITEMS cagitems
527: WHERE b.opt_id = cagitems.opt_Id
528: AND cagitems.CAGR_ENTITLEMENT_ITEM_ID = p_cagr_entitlement_item_id;
529: --