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_PROC_COMMON_ENRT_RSLT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 154: l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;

150: ,p_validate in boolean default false) is
151: --
152: -- Declare cursors and local variables
153: --
154: l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;
155: l_pil_elctbl_chc_popl_id ben_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id%TYPE;
156: l_proc varchar2(72) := g_package||'set_elcn_made_or_asnd_dt';
157: --
158: cursor c_pgm_popl is

Line 155: l_pil_elctbl_chc_popl_id ben_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id%TYPE;

151: --
152: -- Declare cursors and local variables
153: --
154: l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;
155: l_pil_elctbl_chc_popl_id ben_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id%TYPE;
156: l_proc varchar2(72) := g_package||'set_elcn_made_or_asnd_dt';
157: --
158: cursor c_pgm_popl is
159: select pel.pil_elctbl_chc_popl_id

Line 162: from ben_pil_elctbl_chc_popl pel

158: cursor c_pgm_popl is
159: select pel.pil_elctbl_chc_popl_id
160: ,pel.object_version_number
161: ,pel.elcns_made_dt
162: from ben_pil_elctbl_chc_popl pel
163: where pel.per_in_ler_id = p_per_in_ler_id
164: and pel.pgm_id = p_pgm_id;
165: --
166: cursor c_pl_popl is

Line 170: from ben_pil_elctbl_chc_popl pel

166: cursor c_pl_popl is
167: select pel.pil_elctbl_chc_popl_id
168: ,pel.object_version_number
169: ,pel.elcns_made_dt
170: from ben_pil_elctbl_chc_popl pel
171: where pel.per_in_ler_id = p_per_in_ler_id
172: and pel.pl_id = p_pl_id;
173: --
174: -- Added the cursor to fix bug 1644520

Line 263: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

259: --
260: if l_old_elcns_made_dt is null or
261: l_old_elcns_made_dt <> l_new_elcns_made_dt then
262: --
263: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
264: (p_validate => p_validate
265: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
266: ,p_elcns_made_dt => nvl(l_new_elcns_made_dt ,p_effective_date)
267: ,p_object_version_number => l_object_version_number

Line 284: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

280: --
281: --
282: -- Update default assigned date on pil_elctbl_chc_popl.
283: --
284: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
285: (p_validate => p_validate
286: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
287: ,p_dflt_asnd_dt => p_effective_date
288: ,p_object_version_number => l_object_version_number

Line 300: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

296: hr_utility.set_location(l_proc, 20);
297: --
298: -- Update automatic enrollment assigned date on pil_elctbl_chc_popl.
299: --
300: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
301: (p_validate => p_validate
302: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
303: ,p_auto_asnd_dt => p_effective_date
304: ,p_object_version_number => l_object_version_number

Line 896: from ben_pil_elctbl_chc_popl pel,

892: -- Get the asnd_lf_evt_dt
893: --
894: cursor c_pil_elctbl_chc_popl is
895: select enp.asnd_lf_evt_dt
896: from ben_pil_elctbl_chc_popl pel,
897: ben_enrt_perd enp
898: where pel.per_in_ler_id = p_per_in_ler_id
899: and nvl(pel.pgm_id,-1) = nvl(p_pgm_id,-1)
900: and nvl(pel.pl_id,-1) = nvl(p_pl_id,-1)