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_FORMULA_FUNCTIONS dependencies on BEN_OPT_F

Line 312: v_opt_short_code ben_opt_f.short_code%type;

308: ,p_effective_date in date
309: ,p_opt_id in number)
310: RETURN varchar2 is
311:
312: v_opt_short_code ben_opt_f.short_code%type;
313: l_procedure_name varchar2(100);
314:
315: Cursor C1 is
316: select short_code from ben_opt_f

Line 316: select short_code from ben_opt_f

312: v_opt_short_code ben_opt_f.short_code%type;
313: l_procedure_name varchar2(100);
314:
315: Cursor C1 is
316: select short_code from ben_opt_f
317: where opt_id = p_opt_id
318: and p_effective_date between effective_start_date and effective_end_date;
319: Begin
320: l_procedure_name := g_package || '.get_option_short_code';

Line 880: l_opt_name ben_opt_f.name%type;

876: Return Varchar2 is
877:
878: l_proc_name varchar2(100);
879: l_tsp_status Varchar2(60);
880: l_opt_name ben_opt_f.name%type;
881: l_emp_csrs varchar2(1);
882: l_tsp_curr_status varchar2(1);
883: l_val Varchar2(50);
884: l_exists Varchar2(1);

Line 894: Select name from ben_opt_f

890: l_tsp_curr_status_date Varchar2(50);
891: l_dt Varchar2(50);
892:
893: Cursor c_get_tsp_option is
894: Select name from ben_opt_f
895: where opt_id = p_opt_id
896: and business_group_id = p_business_group_id
897: and trunc(p_effective_date) between effective_start_date and effective_end_date;
898:

Line 1029: l_opt_name ben_opt_f.name%type;

1025: l_effective_date Date;
1026: l_pay_start_date Date;
1027: l_pay_end_date Date;
1028: l_agency_dt Varchar2(50);
1029: l_opt_name ben_opt_f.name%type;
1030:
1031: Cursor c_pay_period is
1032: select start_date,end_date
1033: from per_time_periods

Line 1043: from ben_opt_f

1039: and p_effective_date between start_date and end_date;
1040:
1041: Cursor c_get_option_name is
1042: select name
1043: from ben_opt_f
1044: where opt_id = p_opt_id
1045: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1046: Begin
1047:

Line 1134: l_opt_name ben_opt_f.name%type;

1130: l_tspc_rate_start_dt Date;
1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1132: l_pl_id ben_pl_f.pl_id%type;
1133: l_oipl_id ben_oipl_f.oipl_id%type;
1134: l_opt_name ben_opt_f.name%type;
1135:
1136:
1137: l_db_last_pay_end_date Date;
1138: l_db_last_check_date Date;

Line 1214: select name from ben_opt_f

1210: and enrt_cvg_thru_dt = hr_api.g_eot
1211: and prtt_enrt_rslt_stat_cd is null;
1212:
1213: Cursor c_get_opt_name is
1214: select name from ben_opt_f
1215: where opt_id in (select opt_id from ben_oipl_f
1216: where oipl_id = l_oipl_id
1217: and p_effective_date between effective_start_date and
1218: effective_end_date)

Line 1484: v_opt_name ben_opt_f.name%type;

1480:
1481: l_proc_name VARCHAR2(100);
1482: v_eligible VARCHAR2(1);
1483: v_ler_name ben_ler_f.name%type;
1484: v_opt_name ben_opt_f.name%type;
1485: v_pl_name ben_pl_f.name%type;
1486: v_person_id per_all_people_f.person_id%type;
1487: v_coe_date Date;
1488:

Line 1503: from ben_opt_f

1499: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1500:
1501: Cursor c_get_option_name is
1502: select name
1503: from ben_opt_f
1504: where opt_id = p_opt_id
1505: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1506:
1507: Cursor c_get_plan_name is

Line 2068: v_opt_short_code ben_opt_f.name%type;

2064: ,p_effective_date in date
2065: ,p_opt_id in number)
2066: RETURN varchar2 is
2067:
2068: v_opt_short_code ben_opt_f.name%type;
2069: l_procedure_name varchar2(100);
2070:
2071: Cursor C1 is
2072: select short_code from ben_opt_f

Line 2072: select short_code from ben_opt_f

2068: v_opt_short_code ben_opt_f.name%type;
2069: l_procedure_name varchar2(100);
2070:
2071: Cursor C1 is
2072: select short_code from ben_opt_f
2073: where opt_id = p_opt_id
2074: and business_group_id = p_business_group_id
2075: and p_effective_date between effective_start_date and effective_end_date;
2076: Begin

Line 2164: select short_code from ben_opt_f

2160: and perf.prtt_enrt_rslt_stat_cd is null
2161: order by prtt_enrt_rslt_id desc;
2162:
2163: Cursor get_option_code is
2164: select short_code from ben_opt_f
2165: where opt_id = p_option_id
2166: and business_group_id = p_business_group_id
2167: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2168:

Line 2179: l_option_id ben_opt_f.opt_id%type;

2175: l_fegli_code ghr_pa_requests.fegli%type;
2176: l_person_id per_all_assignments_f.person_id%type;
2177: l_payroll_id per_all_assignments_f.payroll_id%type;
2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;
2179: l_option_id ben_opt_f.opt_id%type;
2180: l_ler_name ben_ler_f.name%type;
2181: l_ler_id ben_ler_f.ler_id%type;
2182: l_fegli_event_code varchar2(3);
2183: