APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ELIG_PER_OPT_F

Line 2032: l_object_version_number_opt ben_elig_per_opt_f.object_version_number%type;

2028: l_ptip_id number := p_comp_obj_tree_row.ptip_id;
2029:
2030: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
2031: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
2032: l_object_version_number_opt ben_elig_per_opt_f.object_version_number%type;
2033: l_effective_start_date date;
2034: l_effective_end_date date;
2035: l_datetrack_mode varchar2(100);
2036: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type;

Line 2036: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type;

2032: l_object_version_number_opt ben_elig_per_opt_f.object_version_number%type;
2033: l_effective_start_date date;
2034: l_effective_end_date date;
2035: l_datetrack_mode varchar2(100);
2036: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type;
2037: l_elig_per_oiplip_id ben_elig_per_opt_f.elig_per_opt_id%type;
2038: l_effective_start_date_opt date;
2039: l_effective_end_date_opt date;
2040: l_correction boolean;

Line 2037: l_elig_per_oiplip_id ben_elig_per_opt_f.elig_per_opt_id%type;

2033: l_effective_start_date date;
2034: l_effective_end_date date;
2035: l_datetrack_mode varchar2(100);
2036: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type;
2037: l_elig_per_oiplip_id ben_elig_per_opt_f.elig_per_opt_id%type;
2038: l_effective_start_date_opt date;
2039: l_effective_end_date_opt date;
2040: l_correction boolean;
2041: l_update boolean;

Line 2093: from ben_elig_per_opt_f epo,

2089: pep.elig_per_id,
2090: epo.per_in_ler_id,
2091: pep.prtn_strt_dt strt_dt,
2092: pep.prtn_end_dt end_dt
2093: from ben_elig_per_opt_f epo,
2094: ben_per_in_ler pil,
2095: ben_elig_per_f pep
2096: where pep.person_id = c_person_id
2097: and pep.pl_id = c_pl_id

Line 2133: from ben_elig_per_opt_f epo

2129: and pl_id = p_pl_id;
2130: --
2131: cursor c_epo (p_pgm_id number) is
2132: select null
2133: from ben_elig_per_opt_f epo
2134: where epo.per_in_ler_id is null
2135: and p_effective_date between epo.effective_start_date
2136: and epo.effective_end_date
2137: and epo.elig_per_id in

Line 2148: from ben_elig_per_opt_f epo

2144: and pgm_id = p_pgm_id);
2145: --
2146: cursor c_epo2 (p_pl_id number) is
2147: select null
2148: from ben_elig_per_opt_f epo
2149: where epo.per_in_ler_id is null
2150: and p_effective_date between epo.effective_start_date
2151: and epo.effective_end_date
2152: and epo.elig_per_id in

Line 2203: update ben_elig_per_opt_f epo

2199: fetch c_epo into l_dummy;
2200: if c_epo%found then
2201: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
2202: --
2203: update ben_elig_per_opt_f epo
2204: set per_in_ler_id = p_per_in_ler_id
2205: where epo.per_in_ler_id is null
2206: and epo.elig_per_id in
2207: (select elig_per_id from ben_elig_per_f pep

Line 2245: update ben_elig_per_opt_f epo

2241: if c_epo2%found then
2242:
2243: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
2244: --
2245: update ben_elig_per_opt_f epo
2246: set per_in_ler_id = p_per_in_ler_id
2247: where epo.per_in_ler_id is null
2248: and epo.elig_per_id in
2249: (select elig_per_id from ben_elig_per_f pep