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_CVRD_DPNT_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_ACTN_F

Line 26: ben_prtt_enrt_actn_f pea,

22: pea.cmpltd_dt,
23: pen.object_version_number rslt_ovn,
24: pea.object_version_number
25: from ben_prtt_enrt_rslt_f pen,
26: ben_prtt_enrt_actn_f pea,
27: ben_elig_cvrd_dpnt_f pdp
28: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
29: and pea.elig_cvrd_dpnt_id = pdp.elig_cvrd_dpnt_id
30: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;

142: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
147: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
148: --
149: cursor c_pdp is
150: select pdp.prtt_enrt_rslt_id

Line 772: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

768: l_prtt_enrt_actn_id number(15) := null;
769: l_prtt_enrt_rslt_id number(15);
770: l_rslt_object_version_number number(15);
771: l_exist varchar2(1) := 'N';
772: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
773: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
774: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
775: --
776: cursor get_actn_c is

Line 773: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

769: l_prtt_enrt_rslt_id number(15);
770: l_rslt_object_version_number number(15);
771: l_exist varchar2(1) := 'N';
772: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
773: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
774: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
775: --
776: cursor get_actn_c is
777: select prtt_enrt_actn_id

Line 774: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

770: l_rslt_object_version_number number(15);
771: l_exist varchar2(1) := 'N';
772: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
773: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
774: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
775: --
776: cursor get_actn_c is
777: select prtt_enrt_actn_id
778: from ben_cvrd_dpnt_ctfn_prvdd_f

Line 796: from ben_prtt_enrt_actn_f pea,

792: cursor actn_info_c is
793: select pea.object_version_number,
794: pea.prtt_enrt_rslt_id,
795: pen.object_version_number
796: from ben_prtt_enrt_actn_f pea,
797: ben_prtt_enrt_rslt_f pen
798: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
799: and pea.business_group_id = p_business_group_id
800: and pen.prtt_enrt_rslt_stat_cd is null

Line 1016: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

1012: l_prtt_enrt_actn_id number(15) := null;
1013: l_prtt_enrt_rslt_id number(15);
1014: l_rslt_object_version_number number(15);
1015: l_exist varchar2(1) := 'N';
1016: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1017: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1018: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1019: --
1020: cursor get_actn_c is

Line 1017: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

1013: l_prtt_enrt_rslt_id number(15);
1014: l_rslt_object_version_number number(15);
1015: l_exist varchar2(1) := 'N';
1016: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1017: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1018: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1019: --
1020: cursor get_actn_c is
1021: select prtt_enrt_actn_id

Line 1018: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

1014: l_rslt_object_version_number number(15);
1015: l_exist varchar2(1) := 'N';
1016: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1017: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1018: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1019: --
1020: cursor get_actn_c is
1021: select prtt_enrt_actn_id
1022: from ben_cvrd_dpnt_ctfn_prvdd_f

Line 1040: from ben_prtt_enrt_actn_f pea,

1036: cursor actn_info_c is
1037: select pea.object_version_number,
1038: pea.prtt_enrt_rslt_id,
1039: pen.object_version_number
1040: from ben_prtt_enrt_actn_f pea,
1041: ben_prtt_enrt_rslt_f pen
1042: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
1043: and pea.business_group_id = p_business_group_id
1044: and pen.prtt_enrt_rslt_stat_cd is null