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_CVRD_DPNT_CTFN_PRVDD_F

Line 504: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_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;
506: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
507: l2_datetrack_mode varchar2(30);
508: --

Line 505: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_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;
506: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
507: l2_datetrack_mode varchar2(30);
508: --
509: cursor dpnt_ctfn_c(x_datetrack_mode varchar2) is

Line 506: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_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;
506: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
507: l2_datetrack_mode varchar2(30);
508: --
509: cursor dpnt_ctfn_c(x_datetrack_mode varchar2) is
510: select bcc.cvrd_dpnt_ctfn_prvdd_id,

Line 512: from ben_cvrd_dpnt_ctfn_prvdd_f bcc ,

508: --
509: cursor dpnt_ctfn_c(x_datetrack_mode varchar2) is
510: select bcc.cvrd_dpnt_ctfn_prvdd_id,
511: bcc.object_version_number
512: from ben_cvrd_dpnt_ctfn_prvdd_f bcc ,
513: ben_prtt_enrt_actn_f bpe
514: where bcc.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
515: and bcc.business_group_id = p_business_group_id
516: and bcc.prtt_enrt_actn_id = bpe.prtt_enrt_actn_id

Line 1383: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;

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;
1387: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;

Line 1384: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%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;
1387: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;
1388: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;

Line 1385: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_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;
1387: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;
1388: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;
1389: l2_datetrack_mode varchar2(30);

Line 1421: from ben_cvrd_dpnt_ctfn_prvdd_f

1417: prtt_enrt_actn_id,
1418: object_version_number,
1419: effective_start_date,
1420: effective_end_date
1421: from ben_cvrd_dpnt_ctfn_prvdd_f
1422: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1423: and business_group_id = p_business_group_id
1424: and l_child_effective_date between effective_start_date
1425: and effective_end_date

Line 1802: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;

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;
1806: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;

Line 1803: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%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;
1806: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;
1807: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;

Line 1804: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_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;
1806: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_date%TYPE;
1807: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;
1808: l2_datetrack_mode varchar2(30);

Line 1840: from ben_cvrd_dpnt_ctfn_prvdd_f

1836: prtt_enrt_actn_id,
1837: object_version_number,
1838: effective_start_date,
1839: effective_end_date
1840: from ben_cvrd_dpnt_ctfn_prvdd_f
1841: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1842: and business_group_id = p_business_group_id
1843: and l_child_effective_date between effective_start_date
1844: and effective_end_date