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_PRTT_ENRT_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 110: from ben_prtt_enrt_ctfn_prvdd_f pcs

106: -- Check if any required is denied.
107: --
108: cursor c_rqd_ctfn_prvdd is
109: select 'Y'
110: from ben_prtt_enrt_ctfn_prvdd_f pcs
111: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
112: and pcs.business_group_id = p_business_group_id
113: and pcs.enrt_ctfn_rqd_flag = 'Y'
114: and p_effective_date

Line 124: from ben_prtt_enrt_ctfn_prvdd_f pcs

120: -- it will be the first record because of "order by" clause.
121: --
122: cursor c_opt_ctfn_prvdd is
123: select decode(pcs.enrt_ctfn_dnd_dt,null,'N','Y')
124: from ben_prtt_enrt_ctfn_prvdd_f pcs
125: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
126: and pcs.business_group_id = p_business_group_id
127: and pcs.enrt_ctfn_rqd_flag = 'N'
128: and p_effective_date

Line 337: l_prtt_enrt_ctfn_prvdd_id ben_prtt_enrt_ctfn_prvdd_f.prtt_enrt_ctfn_prvdd_id%TYPE;

333: ) is
334: --
335: -- Declare cursors and local variables
336: --
337: l_prtt_enrt_ctfn_prvdd_id ben_prtt_enrt_ctfn_prvdd_f.prtt_enrt_ctfn_prvdd_id%TYPE;
338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
340: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_CTFN_PRVDD';
341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;

Line 338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;

334: --
335: -- Declare cursors and local variables
336: --
337: l_prtt_enrt_ctfn_prvdd_id ben_prtt_enrt_ctfn_prvdd_f.prtt_enrt_ctfn_prvdd_id%TYPE;
338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
340: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_CTFN_PRVDD';
341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;

Line 339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;

335: -- Declare cursors and local variables
336: --
337: l_prtt_enrt_ctfn_prvdd_id ben_prtt_enrt_ctfn_prvdd_f.prtt_enrt_ctfn_prvdd_id%TYPE;
338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
340: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_CTFN_PRVDD';
341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
343: --

Line 341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;

337: l_prtt_enrt_ctfn_prvdd_id ben_prtt_enrt_ctfn_prvdd_f.prtt_enrt_ctfn_prvdd_id%TYPE;
338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
340: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_CTFN_PRVDD';
341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
343: --
344: begin
345: --

Line 664: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;

660: --
661: -- Declare cursors and local variables
662: --
663: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_CTFN_PRVDD';
664: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
665: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
666: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
667: --
668: begin

Line 665: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;

661: -- Declare cursors and local variables
662: --
663: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_CTFN_PRVDD';
664: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
665: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
666: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
667: --
668: begin
669: --

Line 666: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;

662: --
663: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_CTFN_PRVDD';
664: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
665: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
666: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
667: --
668: begin
669: --
670: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 964: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;

960: --
961: -- Declare cursors and local variables
962: --
963: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_CTFN_PRVDD';
964: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
965: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
966: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
967: --
968: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type := null;

Line 965: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;

961: -- Declare cursors and local variables
962: --
963: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_CTFN_PRVDD';
964: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
965: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
966: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
967: --
968: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type := null;
969: l_prtt_enrt_rslt_id number(15);

Line 966: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;

962: --
963: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_CTFN_PRVDD';
964: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
965: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
966: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
967: --
968: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type := null;
969: l_prtt_enrt_rslt_id number(15);
970: l_rslt_object_version_number number(15);

Line 981: from ben_prtt_enrt_ctfn_prvdd_f

977: --
978: cursor get_actn_c is
979: select prtt_enrt_actn_id,
980: business_group_id
981: from ben_prtt_enrt_ctfn_prvdd_f
982: where prtt_enrt_ctfn_prvdd_id = p_prtt_enrt_ctfn_prvdd_id
983: and p_effective_date between effective_start_date
984: and effective_end_date;
985: --

Line 988: from ben_prtt_enrt_ctfn_prvdd_f

984: and effective_end_date;
985: --
986: cursor more_ctfn_c is
987: select 'Y'
988: from ben_prtt_enrt_ctfn_prvdd_f
989: where prtt_enrt_actn_id = l_prtt_enrt_actn_id
990: and p_effective_date between effective_start_date
991: and effective_end_date;
992: --