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_OPT_F

Line 10: p_opt_code ben_opt_f.short_code%type,

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,
14: p_temp_appt varchar2 default 'N')

Line 61: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,

57: AND c_effective_date between effective_start_date and effective_end_date
58: AND pl_stat_cd = 'A';
59:
60: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
61: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,
62: c_effective_date ben_pgm_f.effective_start_date%type) is
63: SELECT opt_id
64: FROM ben_opt_f opt
65: WHERE opt.short_code = c_option_code

Line 64: FROM ben_opt_f opt

60: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
61: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type, c_business_group_id ben_pgm_f.business_group_id%type,
62: c_effective_date ben_pgm_f.effective_start_date%type) is
63: SELECT opt_id
64: FROM ben_opt_f opt
65: WHERE opt.short_code = c_option_code
66: AND opt.business_group_id = c_business_group_id
67: AND c_effective_date between effective_start_date and effective_end_date;
68:

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 146: l_opt_code ben_opt_f.short_code%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;
150: l_ptip_id ben_ptip_f.ptip_id%type;

Line 152: l_opt_id ben_opt_f.opt_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;
156: l_ptnl_ler_for_per_id NUMBER;

Line 610: p_opt_name ben_opt_f.name%type,

606: p_person_id per_all_people_f.person_id%type,
607: p_effective_date VARCHAR2,
608: p_business_group_id per_all_people_f.business_group_id%type,
609: p_tsp_status varchar2,
610: p_opt_name ben_opt_f.name%type,
611: p_opt_val number
612: )
613:
614: IS

Line 658: CURSOR get_opt_id(c_opt_name ben_opt_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,

654: AND pln.business_group_id = c_business_group_id
655: AND c_effective_date between effective_start_date and effective_end_date;
656:
657: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
658: CURSOR get_opt_id(c_opt_name ben_opt_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
659: c_effective_date ben_pgm_f.effective_start_date%type) is
660: SELECT opt_id
661: FROM ben_opt_f opt
662: WHERE opt.name = c_opt_name

Line 661: FROM ben_opt_f opt

657: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
658: CURSOR get_opt_id(c_opt_name ben_opt_f.name%type, c_business_group_id ben_pgm_f.business_group_id%type,
659: c_effective_date ben_pgm_f.effective_start_date%type) is
660: SELECT opt_id
661: FROM ben_opt_f opt
662: WHERE opt.name = c_opt_name
663: AND opt.business_group_id = c_business_group_id
664: AND c_effective_date between effective_start_date and effective_end_date;
665:

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 718: l_opt_name ben_opt_f.name%type;

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;
722: l_ptip_id ben_ptip_f.ptip_id%type;

Line 724: l_opt_id ben_opt_f.opt_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;
728: l_ptnl_ler_for_per_id NUMBER;

Line 971: p_opt_code ben_opt_f.short_code%type,

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
975: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,

Line 1014: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type,

1010: AND c_effective_date between effective_start_date and effective_end_date
1011: AND pl_stat_cd = 'A';
1012:
1013: --Cursor to get the opt_id for the EE's Enrollment Screen Entry Value
1014: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type,
1015: c_business_group_id ben_pgm_f.business_group_id%type,
1016: c_effective_date ben_pgm_f.effective_start_date%type) is
1017: SELECT opt_id
1018: FROM ben_opt_f opt

Line 1018: FROM ben_opt_f opt

1014: CURSOR get_opt_id(c_option_code ben_opt_f.short_code%type,
1015: c_business_group_id ben_pgm_f.business_group_id%type,
1016: c_effective_date ben_pgm_f.effective_start_date%type) is
1017: SELECT opt_id
1018: FROM ben_opt_f opt
1019: WHERE opt.short_code = c_option_code
1020: AND opt.business_group_id = c_business_group_id
1021: AND c_effective_date between effective_start_date and effective_end_date;
1022:

Line 1038: c_opt_id ben_opt_f.opt_id%type,

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
1042: FROM ben_oipl_f

Line 1136: l_opt_code ben_opt_f.short_code%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;
1140: l_ptip_id ben_ptip_f.ptip_id%type;

Line 1142: l_opt_id ben_opt_f.opt_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;
1146: l_ptnl_ler_for_per_id NUMBER;