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.GHR_BENEFITS_EIT dependencies on BEN_PL_TYP_F

Line 35: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,

31: AND prtt_enrt_rslt_stat_cd IS NULL
32: AND c_effective_date between effective_start_date and effective_end_date;
33:
34: --Cursor to get the Plan Type Id for the given Business_group_id
35: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
36: c_effective_date ben_pgm_f.effective_start_date%type) is
37: SELECT plt.pl_typ_id
38: FROM ben_pl_typ_f plt
39: WHERE plt.name = c_plan_type -- 'Savings Plan'

Line 38: FROM ben_pl_typ_f plt

34: --Cursor to get the Plan Type Id for the given Business_group_id
35: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
36: c_effective_date ben_pgm_f.effective_start_date%type) is
37: SELECT plt.pl_typ_id
38: FROM ben_pl_typ_f plt
39: WHERE plt.name = c_plan_type -- 'Savings Plan'
40: AND plt.business_group_id = c_business_group_id
41: AND c_effective_date between effective_start_date and effective_end_date;
42:

Line 98: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

94: where ler.business_group_id = c_business_group_id
95: and ler.name = c_life_event
96: and c_effective_date between effective_start_date and effective_end_date;
97:
98: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
99: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
100: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
101: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) IS
102: SELECT elig_per_elctbl_chc_id,

Line 118: Cursor get_elig_chc_id(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

114: AND pil.ler_id = c_ler_id
115: AND pil.person_id = c_person_id
116: AND PER_IN_LER_STAT_CD NOT IN ('BCKDT','PROCD');
117:
118: Cursor get_elig_chc_id(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
119: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
120: c_ptip_id ben_ptip_f.ptip_id%type,
121: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) is
122: select elig_per_elctbl_chc_id,

Line 149: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

145: l_pl_code ben_pl_f.short_code%type ;
146: l_opt_code ben_opt_f.short_code%type;
147: l_pgm_id ben_pgm_f.pgm_id%type;
148: l_err_msg varchar2(2000);
149: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
150: l_ptip_id ben_ptip_f.ptip_id%type;
151: l_pl_id ben_pl_f.pl_id%type;
152: l_opt_id ben_opt_f.opt_id%type;
153: l_plip_id ben_plip_f.plip_id%type;

Line 633: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,

629: AND pgm_id = c_pgm_id
630: AND c_effective_date between effective_start_date and effective_end_date;
631:
632: --Cursor to get the Plan Type Id for the given Business_group_id
633: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
634: c_effective_date ben_pgm_f.effective_start_date%type) is
635: SELECT plt.pl_typ_id
636: FROM ben_pl_typ_f plt
637: WHERE plt.name = c_plan_type -- 'Savings Plan'

Line 636: FROM ben_pl_typ_f plt

632: --Cursor to get the Plan Type Id for the given Business_group_id
633: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
634: c_effective_date ben_pgm_f.effective_start_date%type) is
635: SELECT plt.pl_typ_id
636: FROM ben_pl_typ_f plt
637: WHERE plt.name = c_plan_type -- 'Savings Plan'
638: AND plt.business_group_id = c_business_group_id
639: AND c_effective_date between effective_start_date and effective_end_date;
640:

Line 687: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

683: AND opt_id = c_opt_id
684: AND business_group_id = c_business_group_id
685: AND c_effective_date between effective_start_date and effective_end_date;
686:
687: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
688: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
690: c_person_id per_all_people_f.person_id%type) IS
691: SELECT elig_per_elctbl_chc_id,

Line 721: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

717: l_pl_code ben_pl_f.short_code%type ;
718: l_opt_name ben_opt_f.name%type;
719: l_pgm_id ben_pgm_f.pgm_id%type;
720: l_err_msg varchar2(2000);
721: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
722: l_ptip_id ben_ptip_f.ptip_id%type;
723: l_pl_id ben_pl_f.pl_id%type;
724: l_opt_id ben_opt_f.opt_id%type;
725: l_plip_id ben_plip_f.plip_id%type;

Line 888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

884: END IF;
885:
886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
887:
888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
891: c_person_id per_all_people_f.person_id%type) */
892: hr_utility.set_location('p_manage_life_events done' ,1234);

Line 985: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type,

981: AND pgm.business_group_id = c_business_group_id
982: AND c_effective_date between effective_start_date and effective_end_date;
983:
984: --Cursor to get the Plan Type Id for the given Business_group_id
985: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type,
986: c_business_group_id ben_pgm_f.business_group_id%type,
987: c_effective_date ben_pgm_f.effective_start_date%type) is
988: SELECT plt.pl_typ_id
989: FROM ben_pl_typ_f plt

Line 989: FROM ben_pl_typ_f plt

985: CURSOR c_get_pl_typ_id(c_plan_type ben_pl_typ_f.name%type,
986: c_business_group_id ben_pgm_f.business_group_id%type,
987: c_effective_date ben_pgm_f.effective_start_date%type) is
988: SELECT plt.pl_typ_id
989: FROM ben_pl_typ_f plt
990: WHERE plt.name = c_plan_type
991: AND plt.business_group_id = c_business_group_id
992: AND c_effective_date between effective_start_date and effective_end_date;
993:

Line 1058: c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

1054: AND ler.name = c_life_event
1055: AND c_effective_date between effective_start_date and effective_end_date;
1056:
1057: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type,
1058: c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
1059: c_pl_id ben_pl_f.pl_id%type,
1060: c_plip_id ben_plip_f.plip_id%type,
1061: c_ptip_id ben_ptip_f.ptip_id%type,
1062: c_oipl_id ben_oipl_f.oipl_id%type,

Line 1080: c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,

1076: AND pil.ler_id = c_ler_id
1077: AND pil.person_id = c_person_id;
1078:
1079: CURSOR get_elig_chc_id(c_pgm_id ben_pgm_f.pgm_id%type,
1080: c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
1081: c_pl_id ben_pl_f.pl_id%type,
1082: c_plip_id ben_plip_f.plip_id%type,
1083: c_ptip_id ben_ptip_f.ptip_id%type,
1084: c_ler_id ben_ler_f.ler_id%type,

Line 1139: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

1135: l_pl_code ben_pl_f.short_code%type ;
1136: l_opt_code ben_opt_f.short_code%type;
1137: l_pgm_id ben_pgm_f.pgm_id%type;
1138: l_err_msg varchar2(2000);
1139: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1140: l_ptip_id ben_ptip_f.ptip_id%type;
1141: l_pl_id ben_pl_f.pl_id%type;
1142: l_opt_id ben_opt_f.opt_id%type;
1143: l_plip_id ben_plip_f.plip_id%type;