eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ELIG_PER_F

Line 2030: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;

2026: l_oiplip_id number := p_comp_obj_tree_row.oiplip_id;
2027: l_plip_id number := p_comp_obj_tree_row.plip_id;
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;

Line 2031: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

2027: l_plip_id number := p_comp_obj_tree_row.plip_id;
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);

Line 2060: from ben_elig_per_f pep,

2056: pep.prtn_strt_dt,
2057: pep.prtn_end_dt,
2058: pep.per_in_ler_id,
2059: pep.object_version_number
2060: from ben_elig_per_f pep,
2061: ben_per_in_ler pil
2062: where pep.person_id = c_person_id
2063: and nvl(pep.pgm_id,-1) = c_pgm_id
2064: and nvl(pep.pl_id,-1) = c_pl_id

Line 2095: ben_elig_per_f pep

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
2098: and epo.opt_id = c_opt_id
2099: and pep.elig_per_id = epo.elig_per_id

Line 2114: from ben_elig_per_f

2110: or pil.per_in_ler_stat_cd is null);
2111: --
2112: cursor c_epe (p_pgm_id number) is
2113: select null
2114: from ben_elig_per_f
2115: where person_id = p_person_id
2116: and p_effective_date between effective_start_date and
2117: effective_end_date
2118: and per_in_ler_id is null

Line 2123: from ben_elig_per_f

2119: and pgm_id = p_pgm_id;
2120: --
2121: cursor c_epe2 (p_pl_id number) is
2122: select null
2123: from ben_elig_per_f
2124: where person_id = p_person_id
2125: and p_effective_date between effective_start_date and
2126: effective_end_date
2127: and per_in_ler_id is null

Line 2139: from ben_elig_per_f

2135: and p_effective_date between epo.effective_start_date
2136: and epo.effective_end_date
2137: and epo.elig_per_id in
2138: (select elig_per_id
2139: from ben_elig_per_f
2140: where person_id = p_person_id
2141: and p_effective_date between effective_start_date and
2142: effective_end_date
2143: and per_in_ler_id = p_per_in_ler_id

Line 2154: from ben_elig_per_f

2150: and p_effective_date between epo.effective_start_date
2151: and epo.effective_end_date
2152: and epo.elig_per_id in
2153: (select elig_per_id
2154: from ben_elig_per_f
2155: where person_id = p_person_id
2156: and p_effective_date between effective_start_date and
2157: effective_end_date
2158: and per_in_ler_id = p_per_in_ler_id

Line 2186: update ben_elig_per_f pep set per_in_ler_id = p_per_in_ler_id

2182: open c_epe (l_envpgm_id);
2183: fetch c_epe into l_dummy;
2184: if c_epe%found then
2185: --
2186: update ben_elig_per_f pep set per_in_ler_id = p_per_in_ler_id
2187: where pep.person_id = p_person_id
2188: and pep.per_in_ler_id is null
2189: and pep.pgm_id = l_envpgm_id
2190: and p_effective_date between pep.effective_start_date

Line 2207: (select elig_per_id from ben_elig_per_f pep

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
2208: where pep.pgm_id = l_envpgm_id
2209: and pep.per_in_ler_id = p_per_in_ler_id
2210: and p_effective_date between pep.effective_start_date
2211: and pep.effective_end_date)

Line 2226: update ben_elig_per_f pep set per_in_ler_id = p_per_in_ler_id

2222: open c_epe2(l_envpl_id);
2223: fetch c_epe2 into l_dummy;
2224: if c_epe2%found then
2225: --
2226: update ben_elig_per_f pep set per_in_ler_id = p_per_in_ler_id
2227: where pep.person_id = p_person_id
2228: and pep.per_in_ler_id is null
2229: and pep.pgm_id is null
2230: and pep.pl_id = l_envpl_id

Line 2249: (select elig_per_id from ben_elig_per_f pep

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
2250: where pep.pgm_id is null
2251: and pep.pl_id = l_envpl_id
2252: and pep.per_in_ler_id = p_per_in_ler_id
2253: and p_effective_date between pep.effective_start_date

Line 9847: from ben_elig_per_f pep

9843: cursor c_get_ptip_elig(p_ptip_id number
9844: ,p_per_in_ler_id number
9845: ) is
9846: select pep.elig_flag
9847: from ben_elig_per_f pep
9848: where pep.per_in_ler_id = p_per_in_ler_id
9849: and pep.ptip_id = p_ptip_id
9850: and pep.business_group_id = p_business_group_id
9851: and p_effective_date between pep.effective_start_date