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_PRTN_ELIG_PRFL_API dependencies on BEN_PRTN_ELIG_PRFL_F

Line 74: l_prtn_elig_prfl_id ben_prtn_elig_prfl_f.prtn_elig_prfl_id%TYPE;

70: l_plip_id number;
71: l_oipl_id number;
72: l_ptip_id number;
73: l_prtn_elig_id number;
74: l_prtn_elig_prfl_id ben_prtn_elig_prfl_f.prtn_elig_prfl_id%TYPE;
75: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
76: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_PRTN_ELIG_PRFL';
78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;

Line 75: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;

71: l_oipl_id number;
72: l_ptip_id number;
73: l_prtn_elig_id number;
74: l_prtn_elig_prfl_id ben_prtn_elig_prfl_f.prtn_elig_prfl_id%TYPE;
75: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
76: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_PRTN_ELIG_PRFL';
78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
79: --

Line 76: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;

72: l_ptip_id number;
73: l_prtn_elig_id number;
74: l_prtn_elig_prfl_id ben_prtn_elig_prfl_f.prtn_elig_prfl_id%TYPE;
75: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
76: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_PRTN_ELIG_PRFL';
78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
79: --
80: begin

Line 78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;

74: l_prtn_elig_prfl_id ben_prtn_elig_prfl_f.prtn_elig_prfl_id%TYPE;
75: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
76: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_PRTN_ELIG_PRFL';
78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
79: --
80: begin
81: --
82: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 446: from ben_prtn_elig_prfl_f

442: -- Declare cursors and local variables
443: -- 3688111
444: cursor c_cep is
445: select eligy_prfl_id
446: from ben_prtn_elig_prfl_f
447: where prtn_elig_prfl_id = p_prtn_elig_prfl_id
448: and p_effective_date between effective_start_date and effective_end_date ;
449:
450: cursor c1 is

Line 457: ben_prtn_elig_prfl_f b

453: plip_id,
454: pl_id,
455: oipl_id
456: from ben_prtn_elig_f a,
457: ben_prtn_elig_prfl_f b
458: where a.prtn_elig_id = b.prtn_elig_id
459: and b.prtn_elig_prfl_id = p_prtn_elig_prfl_id;
460: l_c1 c1%rowtype;
461: --

Line 495: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;

491: and p_effective_date between effective_start_date and effective_end_date ;
492:
493: --
494: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
495: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
496: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
497: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
498: -- 3688111
499: l_old_eligy_prfl_id number ;

Line 496: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;

492:
493: --
494: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
495: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
496: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
497: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
498: -- 3688111
499: l_old_eligy_prfl_id number ;
500: l_drvbl_fctr_prtn_elig_flag varchar2(30) ;

Line 497: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;

493: --
494: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
495: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
496: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
497: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
498: -- 3688111
499: l_old_eligy_prfl_id number ;
500: l_drvbl_fctr_prtn_elig_flag varchar2(30) ;
501: --

Line 844: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;

840: --
841: -- Declare cursors and local variables
842: --
843: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
844: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
845: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
846: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
847: --
848: cursor c1 is

Line 845: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;

841: -- Declare cursors and local variables
842: --
843: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
844: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
845: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
846: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
847: --
848: cursor c1 is
849: select pgm_id,

Line 846: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;

842: --
843: l_proc varchar2(72) := g_package||'update_PRTN_ELIG_PRFL';
844: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
845: l_effective_start_date ben_prtn_elig_prfl_f.effective_start_date%TYPE;
846: l_effective_end_date ben_prtn_elig_prfl_f.effective_end_date%TYPE;
847: --
848: cursor c1 is
849: select pgm_id,
850: ptip_id,

Line 855: ben_prtn_elig_prfl_f b

851: plip_id,
852: pl_id,
853: oipl_id
854: from ben_prtn_elig_f a,
855: ben_prtn_elig_prfl_f b
856: where a.prtn_elig_id = b.prtn_elig_id
857: and b.prtn_elig_prfl_id = p_prtn_elig_prfl_id;
858: --
859: l_c1 c1%rowtype;

Line 945: ben_prtn_elig_prfl_f b

941: set c.elig_apls_flag = 'N'
942: where not exists
943: (select a.pgm_id
944: from ben_prtn_elig_f a,
945: ben_prtn_elig_prfl_f b
946: where a.prtn_elig_id = b.prtn_elig_id
947: and a.pgm_id = c.pgm_id)
948: and not exists
949: (select a.pgm_id

Line 967: ben_prtn_elig_prfl_f b

963: set c.elig_apls_flag = 'N'
964: where not exists
965: (select a.plip_id
966: from ben_prtn_elig_f a,
967: ben_prtn_elig_prfl_f b
968: where a.prtn_elig_id = b.prtn_elig_id
969: and a.plip_id = c.plip_id)
970: and not exists
971: (select a.plip_id

Line 990: ben_prtn_elig_prfl_f b

986: set c.elig_apls_flag = 'N'
987: where not exists
988: (select a.ptip_id
989: from ben_prtn_elig_f a,
990: ben_prtn_elig_prfl_f b
991: where a.prtn_elig_id = b.prtn_elig_id
992: and a.ptip_id = c.ptip_id)
993: and not exists
994: (select a.ptip_id

Line 1012: ben_prtn_elig_prfl_f b

1008: set c.elig_apls_flag = 'N'
1009: where not exists
1010: (select a.pl_id
1011: from ben_prtn_elig_f a,
1012: ben_prtn_elig_prfl_f b
1013: where a.prtn_elig_id = b.prtn_elig_id
1014: and a.pl_id = c.pl_id)
1015: and not exists
1016: (select a.pl_id

Line 1035: ben_prtn_elig_prfl_f b

1031: set c.elig_apls_flag = 'N'
1032: where not exists
1033: (select a.oipl_id
1034: from ben_prtn_elig_f a,
1035: ben_prtn_elig_prfl_f b
1036: where a.prtn_elig_id = b.prtn_elig_id
1037: and a.oipl_id = c.oipl_id)
1038: and not exists
1039: (select a.oipl_id