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_PRMRY_CARE_PRVDR_F

Line 555: from ben_prmry_care_prvdr_f pcp

551: ,pcp.EFFECTIVE_END_DATE
552: ,pcp.PRTT_ENRT_RSLT_ID
553: ,pcp.BUSINESS_GROUP_ID
554: ,pcp.OBJECT_VERSION_NUMBER
555: from ben_prmry_care_prvdr_f pcp
556: where business_group_id = p_business_group_id
557: and elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
558: and c_pcp_effective_date between effective_start_date --3631067: Changed p_effective_date to c_pcp_effective_date
559: and effective_end_date

Line 571: from ben_prmry_care_prvdr_f pcp

567: ,pcp.EFFECTIVE_END_DATE
568: ,pcp.PRTT_ENRT_RSLT_ID
569: ,pcp.BUSINESS_GROUP_ID
570: ,pcp.OBJECT_VERSION_NUMBER
571: from ben_prmry_care_prvdr_f pcp
572: where pcp.business_group_id = p_business_group_id
573: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
574: and c_pcp_effective_date < pcp.effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
575: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot

Line 1386: l3_object_version_number ben_prmry_care_prvdr_f.object_version_number%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);
1390: l_child_effective_date date;

Line 1387: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_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);
1390: l_child_effective_date date;
1391: --

Line 1388: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%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);
1390: l_child_effective_date date;
1391: --
1392: cursor dpnt_info_c is

Line 1431: from ben_prmry_care_prvdr_f

1427: --
1428: cursor dpnt_pcp_c is
1429: select prmry_care_prvdr_id,
1430: object_version_number
1431: from ben_prmry_care_prvdr_f
1432: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1433: and business_group_id = p_business_group_id
1434: and p_effective_date between effective_start_date
1435: and effective_end_date;

Line 1805: l3_object_version_number ben_prmry_care_prvdr_f.object_version_number%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);
1809: l_child_effective_date date;

Line 1806: l3_effective_start_date ben_prmry_care_prvdr_f.effective_start_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);
1809: l_child_effective_date date;
1810: --

Line 1807: l3_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%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);
1809: l_child_effective_date date;
1810: --
1811: cursor dpnt_info_c is

Line 1850: from ben_prmry_care_prvdr_f

1846: --
1847: cursor dpnt_pcp_c is
1848: select prmry_care_prvdr_id,
1849: object_version_number
1850: from ben_prmry_care_prvdr_f
1851: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1852: and business_group_id = p_business_group_id
1853: and p_effective_date between effective_start_date
1854: and effective_end_date;