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_F

Line 9: p_pl_code ben_pl_f.short_code%type,

5: retcode OUT NOCOPY NUMBER,
6: p_person_id per_all_people_f.person_id%type,
7: p_effective_date VARCHAR2,
8: p_business_group_id per_all_people_f.business_group_id%type,
9: p_pl_code ben_pl_f.short_code%type,
10: p_opt_code ben_opt_f.short_code%type,
11: p_pre_tax varchar2,
12: p_assignment_id per_all_assignments_f.assignment_id%type,
13: p_temps_total_cost varchar2,

Line 51: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,

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:
51: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,
52: c_effective_date ben_pgm_f.effective_start_date%type) is
53: SELECT pln.pl_id pl_id
54: FROM ben_pl_f pln
55: WHERE pln.short_code = c_health_plan

Line 54: FROM ben_pl_f pln

50:
51: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,
52: c_effective_date ben_pgm_f.effective_start_date%type) is
53: SELECT pln.pl_id pl_id
54: FROM ben_pl_f pln
55: WHERE pln.short_code = c_health_plan
56: AND pln.business_group_id = c_business_group_id
57: AND c_effective_date between effective_start_date and effective_end_date
58: AND pl_stat_cd = 'A';

Line 81: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,

77: AND c_effective_date between effective_start_date and effective_end_date;
78:
79: -- Cursor to get the option in plan Id
80:
81: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
82: c_effective_date ben_pgm_f.effective_start_date%type) is
83: SELECT oipl_id
84: FROM ben_oipl_f
85: WHERE pl_id = c_pl_id

Line 99: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

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

Line 119: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

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

Line 145: l_pl_code ben_pl_f.short_code%type ;

141: l_person_id per_all_people_f.person_id%type ;
142: l_effective_date date;
143: l_warning boolean;
144: l_business_group_id per_all_people_f.business_group_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;

Line 151: l_pl_id ben_pl_f.pl_id%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;
155: l_ler_id ben_ler_f.ler_id%type;

Line 649: CURSOR get_pl_id(c_pl_name ben_pl_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,

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:
649: CURSOR get_pl_id(c_pl_name ben_pl_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
650: c_effective_date ben_pgm_f.effective_start_date%type) is
651: SELECT pln.pl_id pl_id
652: FROM ben_pl_f pln
653: WHERE pln.name = c_pl_name

Line 652: FROM ben_pl_f pln

648:
649: CURSOR get_pl_id(c_pl_name ben_pl_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
650: c_effective_date ben_pgm_f.effective_start_date%type) is
651: SELECT pln.pl_id pl_id
652: FROM ben_pl_f pln
653: WHERE pln.name = c_pl_name
654: AND pln.business_group_id = c_business_group_id
655: AND c_effective_date between effective_start_date and effective_end_date;
656:

Line 678: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,

674: AND c_effective_date between effective_start_date and effective_end_date;
675:
676: -- Cursor to get the option in plan Id
677:
678: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
679: c_effective_date ben_pgm_f.effective_start_date%type) is
680: SELECT oipl_id
681: FROM ben_oipl_f
682: WHERE pl_id = c_pl_id

Line 688: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

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,
692: pil.per_in_ler_id

Line 717: l_pl_code ben_pl_f.short_code%type ;

713: l_exists BOOLEAN;
714: l_person_id per_all_people_f.person_id%type ;
715: l_effective_date date;
716: l_business_group_id per_all_people_f.business_group_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;

Line 723: l_pl_id ben_pl_f.pl_id%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;
727: l_ler_id ben_ler_f.ler_id%type;

Line 889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

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);
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 ,

Line 970: p_pl_code ben_pl_f.short_code%type,

966: retcode OUT NOCOPY NUMBER,
967: p_person_id per_all_people_f.person_id%type,
968: p_effective_date VARCHAR2,
969: p_business_group_id per_all_people_f.business_group_id%type,
970: p_pl_code ben_pl_f.short_code%type,
971: p_opt_code ben_opt_f.short_code%type,
972: p_assignment_id per_all_assignments_f.assignment_id%type) IS
973:
974: -- Cursor to get Program

Line 1003: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type,

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:
1003: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type,
1004: c_business_group_id ben_pgm_f.business_group_id%type,
1005: c_effective_date ben_pgm_f.effective_start_date%type) is
1006: SELECT pln.pl_id pl_id
1007: FROM ben_pl_f pln

Line 1007: FROM ben_pl_f pln

1003: CURSOR get_pl_id(c_health_plan ben_pl_f.short_code%type,
1004: c_business_group_id ben_pgm_f.business_group_id%type,
1005: c_effective_date ben_pgm_f.effective_start_date%type) is
1006: SELECT pln.pl_id pl_id
1007: FROM ben_pl_f pln
1008: WHERE pln.short_code = c_health_plan
1009: AND pln.business_group_id = c_business_group_id
1010: AND c_effective_date between effective_start_date and effective_end_date
1011: AND pl_stat_cd = 'A';

Line 1037: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type,

1033: AND c_effective_date between effective_start_date and effective_end_date;
1034:
1035: -- Cursor to get the option in plan Id
1036:
1037: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type,
1038: c_opt_id ben_opt_f.opt_id%type,
1039: c_business_group_id ben_pgm_f.business_group_id%type,
1040: c_effective_date ben_pgm_f.effective_start_date%type) is
1041: SELECT oipl_id

Line 1059: c_pl_id ben_pl_f.pl_id%type,

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,
1063: c_ler_id ben_ler_f.ler_id%type,

Line 1081: c_pl_id ben_pl_f.pl_id%type,

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,
1085: c_person_id per_all_people_f.person_id%type) is

Line 1135: l_pl_code ben_pl_f.short_code%type ;

1131: l_person_id per_all_people_f.person_id%type ;
1132: l_effective_date date;
1133: l_warning boolean;
1134: l_business_group_id per_all_people_f.business_group_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;

Line 1141: l_pl_id ben_pl_f.pl_id%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;
1145: l_ler_id ben_ler_f.ler_id%type;