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_ELIG_CVRD_DPNT_API dependencies on BEN_ELIG_CVRD_DPNT_F

Line 68: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

64: ) is
65: --
66: -- Declare cursors and local variables
67: --
68: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
72: l_proc varchar2(72) := g_package||'create_ELIG_CVRD_DPNT';

Line 69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;

65: --
66: -- Declare cursors and local variables
67: --
68: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
72: l_proc varchar2(72) := g_package||'create_ELIG_CVRD_DPNT';
73: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;

Line 70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

66: -- Declare cursors and local variables
67: --
68: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
72: l_proc varchar2(72) := g_package||'create_ELIG_CVRD_DPNT';
73: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
74: --

Line 71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;

67: --
68: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
72: l_proc varchar2(72) := g_package||'create_ELIG_CVRD_DPNT';
73: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
74: --
75: cursor c_chg_info (p_prtt_enrt_rslt_id number) is

Line 73: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;

69: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
70: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
71: l_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
72: l_proc varchar2(72) := g_package||'create_ELIG_CVRD_DPNT';
73: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
74: --
75: cursor c_chg_info (p_prtt_enrt_rslt_id number) is
76: SELECT pen.pl_id,
77: pen.oipl_id,

Line 499: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;

495: --
496: -- Declare cursors and local variables
497: --
498: l_proc varchar2(72) := g_package||'update_ELIG_CVRD_DPNT';
499: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
500: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
501: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
502: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
503: --

Line 500: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;

496: -- Declare cursors and local variables
497: --
498: l_proc varchar2(72) := g_package||'update_ELIG_CVRD_DPNT';
499: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
500: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
501: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
502: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
503: --
504: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;

Line 501: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

497: --
498: l_proc varchar2(72) := g_package||'update_ELIG_CVRD_DPNT';
499: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
500: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
501: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
502: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
503: --
504: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
505: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;

Line 538: ben_elig_cvrd_dpnt_f pdp

534: pen.pl_id,
535: pen.oipl_id,
536: pen.person_id
537: FROM ben_prtt_enrt_rslt_f pen,
538: ben_elig_cvrd_dpnt_f pdp
539: WHERE pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
540: AND pen.prtt_enrt_rslt_stat_cd is null
541: and p_effective_date between pdp.effective_start_date and pdp.effective_end_date
542: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id

Line 1106: from ben_elig_cvrd_dpnt_f

1102: cursor get_dpnt_info_c is
1103: select dpnt_person_id,
1104: cvg_strt_dt,
1105: business_group_id
1106: from ben_elig_cvrd_dpnt_f
1107: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1108: and p_effective_date between effective_start_date
1109: and effective_end_date;
1110: --

Line 1113: from ben_elig_cvrd_dpnt_f a,

1109: and effective_end_date;
1110: --
1111: cursor other_dpnt_c is
1112: select null
1113: from ben_elig_cvrd_dpnt_f a,
1114: ben_per_in_ler pil
1115: where a.dpnt_person_id = l_dpnt_person_id
1116: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
1117: and a.cvg_strt_dt is not null

Line 1284: from ben_elig_cvrd_dpnt_f

1280: select dpnt_person_id,
1281: cvg_strt_dt,
1282: business_group_id,
1283: prtt_enrt_rslt_id
1284: from ben_elig_cvrd_dpnt_f
1285: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1286: and p_effective_date between effective_start_date
1287: and effective_end_date;
1288: --

Line 1379: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;

1375: --
1376: -- Declare cursors and local variables
1377: --
1378: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1379: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1382: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1383: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;

Line 1380: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;

1376: -- Declare cursors and local variables
1377: --
1378: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1379: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1382: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1383: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1384: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;

Line 1381: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

1377: --
1378: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1379: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1382: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1383: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1384: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1385: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;

Line 1382: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

1378: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1379: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1382: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1383: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1384: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1385: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
1386: l3_object_version_number ben_prmry_care_prvdr_f.object_version_number%TYPE;

Line 1398: from ben_elig_cvrd_dpnt_f

1394: cvg_thru_dt,
1395: dpnt_person_id,
1396: prtt_enrt_rslt_id,
1397: per_in_ler_id
1398: from ben_elig_cvrd_dpnt_f
1399: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1400: and business_group_id = p_business_group_id
1401: and p_effective_date between effective_start_date
1402: and effective_end_date;

Line 1798: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;

1794: --
1795: -- Declare cursors and local variables
1796: --
1797: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1798: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1799: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1800: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1801: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1802: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;

Line 1799: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;

1795: -- Declare cursors and local variables
1796: --
1797: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1798: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1799: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1800: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1801: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1802: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1803: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;

Line 1800: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

1796: --
1797: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1798: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1799: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1800: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1801: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1802: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1803: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1804: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;

Line 1801: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;

1797: l_proc varchar2(72) := g_package||'delete_ELIG_CVRD_DPNT';
1798: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
1799: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
1800: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1801: l_parent_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
1802: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1803: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1804: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
1805: l3_object_version_number ben_prmry_care_prvdr_f.object_version_number%TYPE;

Line 1817: from ben_elig_cvrd_dpnt_f

1813: cvg_thru_dt,
1814: dpnt_person_id,
1815: prtt_enrt_rslt_id,
1816: per_in_ler_id
1817: from ben_elig_cvrd_dpnt_f
1818: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1819: and business_group_id = p_business_group_id
1820: and p_effective_date between effective_start_date
1821: and effective_end_date;

Line 2285: from ben_elig_cvrd_dpnt_f

2281: --
2282: cursor get_rslt_id_c is
2283: select prtt_enrt_rslt_id,
2284: business_group_id
2285: from ben_elig_cvrd_dpnt_f
2286: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2287: and p_effective_date between effective_start_date
2288: and effective_end_date;
2289: --

Line 2391: from ben_elig_cvrd_dpnt_f

2387: cursor get_dpnt_info_c is
2388: select dpnt_person_id,
2389: cvg_strt_dt,
2390: business_group_id
2391: from ben_elig_cvrd_dpnt_f
2392: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2393: and p_effective_date between effective_start_date
2394: and effective_end_date;
2395: --

Line 2558: from ben_elig_cvrd_dpnt_f

2554: cursor get_dpnt_info_c is
2555: select dpnt_person_id,
2556: cvg_strt_dt,
2557: business_group_id
2558: from ben_elig_cvrd_dpnt_f
2559: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2560: and p_effective_date between effective_start_date
2561: and effective_end_date;
2562: --

Line 2565: from ben_elig_cvrd_dpnt_f a,

2561: and effective_end_date;
2562: --
2563: cursor other_dpnt_c is
2564: select null
2565: from ben_elig_cvrd_dpnt_f a,
2566: ben_per_in_ler pil
2567: where a.dpnt_person_id = l_dpnt_person_id
2568: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
2569: and a.cvg_strt_dt is not null

Line 2720: ben_elig_cvrd_dpnt_f egd,

2716: ,o.opt_id
2717: ,egd.cvg_strt_dt
2718: ,egd.cvg_thru_dt
2719: from ben_prtt_enrt_rslt_f r,
2720: ben_elig_cvrd_dpnt_f egd,
2721: ben_oipl_f o ,
2722: ben_per_in_ler pil
2723: where r.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2724: and r.prtt_enrt_rslt_id = egd.prtt_enrt_rslt_id

Line 2836: from ben_elig_cvrd_dpnt_f ecd ,

2832: --
2833: cursor total_num_dpnt_c(cv_cvg_strt_dt date,
2834: cv_cvg_thru_dt date) is
2835: select count(elig_cvrd_dpnt_id)
2836: from ben_elig_cvrd_dpnt_f ecd ,
2837: ben_per_in_ler pil
2838: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2839: and ecd.cvg_strt_dt is not null
2840: and ecd.cvg_thru_dt = hr_api.g_eot

Line 2860: , ben_elig_cvrd_dpnt_f d

2856: cv_cvg_strt_dt date,
2857: cv_cvg_thru_dt date) is
2858: select count(*)
2859: from per_contact_relationships c
2860: , ben_elig_cvrd_dpnt_f d
2861: , ben_per_in_ler pil
2862: where
2863: c.person_id = cv_person_id
2864: and c.contact_person_id = d.dpnt_person_id