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_PTIP_F

Line 43: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,

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:
43: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,
44: c_effective_date ben_pgm_f.effective_start_date%type) is
45: SELECT ptip_id
46: FROM ben_ptip_f
47: WHERE pl_typ_id = c_plan_type_id

Line 46: FROM ben_ptip_f

42:
43: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,
44: c_effective_date ben_pgm_f.effective_start_date%type) is
45: SELECT ptip_id
46: FROM ben_ptip_f
47: WHERE pl_typ_id = c_plan_type_id
48: AND pgm_id = c_pgm_id
49: AND c_effective_date between effective_start_date and effective_end_date;
50:

Line 100: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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,
103: pil.per_in_ler_id,
104: prtt_enrt_rslt_id

Line 120: c_ptip_id ben_ptip_f.ptip_id%type,

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,
123: pil.per_in_ler_id,
124: prtt_enrt_rslt_id

Line 150: l_ptip_id ben_ptip_f.ptip_id%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;
154: l_oipl_id ben_oipl_f.oipl_id%type;

Line 641: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,

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:
641: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,
642: c_effective_date ben_pgm_f.effective_start_date%type) is
643: SELECT ptip_id
644: FROM ben_ptip_f
645: WHERE pl_typ_id = c_plan_type_id

Line 644: FROM ben_ptip_f

640:
641: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type, c_pgm_id ben_ptip_f.pgm_id%type,
642: c_effective_date ben_pgm_f.effective_start_date%type) is
643: SELECT ptip_id
644: FROM ben_ptip_f
645: WHERE pl_typ_id = c_plan_type_id
646: AND pgm_id = c_pgm_id
647: AND c_effective_date between effective_start_date and effective_end_date;
648:

Line 689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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,
692: pil.per_in_ler_id
693: FROM ben_elig_per_ELCTBL_chc chc ,

Line 722: l_ptip_id ben_ptip_f.ptip_id%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;
726: l_oipl_id ben_oipl_f.oipl_id%type;

Line 890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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);
893: for get_elig_chc_id in get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
894: l_ptip_id , l_oipl_id , l_person_id) loop

Line 994: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type,

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:
994: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type,
995: c_pgm_id ben_ptip_f.pgm_id%type,
996: c_effective_date ben_pgm_f.effective_start_date%type) is
997: SELECT ptip_id
998: FROM ben_ptip_f

Line 995: c_pgm_id ben_ptip_f.pgm_id%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:
994: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type,
995: c_pgm_id ben_ptip_f.pgm_id%type,
996: c_effective_date ben_pgm_f.effective_start_date%type) is
997: SELECT ptip_id
998: FROM ben_ptip_f
999: WHERE pl_typ_id = c_plan_type_id

Line 998: FROM ben_ptip_f

994: CURSOR get_ptip_id(c_plan_type_id ben_ptip_f.pl_typ_id%type,
995: c_pgm_id ben_ptip_f.pgm_id%type,
996: c_effective_date ben_pgm_f.effective_start_date%type) is
997: SELECT ptip_id
998: FROM ben_ptip_f
999: WHERE pl_typ_id = c_plan_type_id
1000: AND pgm_id = c_pgm_id
1001: AND c_effective_date between effective_start_date and effective_end_date;
1002:

Line 1061: c_ptip_id ben_ptip_f.ptip_id%type,

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,
1063: c_ler_id ben_ler_f.ler_id%type,
1064: c_person_id per_all_people_f.person_id%type) is
1065: SELECT elig_per_elctbl_chc_id,

Line 1083: c_ptip_id ben_ptip_f.ptip_id%type,

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,
1085: c_person_id per_all_people_f.person_id%type) is
1086: SELECT elig_per_elctbl_chc_id,
1087: pil.per_in_ler_id

Line 1140: l_ptip_id ben_ptip_f.ptip_id%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;
1144: l_oipl_id ben_oipl_f.oipl_id%type;