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

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

Line 1041: from ben_opt_f

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

Line 1130: l_opt_name ben_opt_f.name%type;

1126: l_tspc_rate_start_dt Date;
1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1128: l_pl_id ben_pl_f.pl_id%type;
1129: l_oipl_id ben_oipl_f.oipl_id%type;
1130: l_opt_name ben_opt_f.name%type;
1131:
1132:
1133: l_db_last_pay_end_date Date;
1134: l_db_last_check_date Date;

Line 1210: select name from ben_opt_f

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

Line 1480: v_opt_name ben_opt_f.name%type;

1476:
1477: l_proc_name VARCHAR2(100);
1478: v_eligible VARCHAR2(1);
1479: v_ler_name ben_ler_f.name%type;
1480: v_opt_name ben_opt_f.name%type;
1481: v_pl_name ben_pl_f.name%type;
1482: v_person_id per_all_people_f.person_id%type;
1483: v_coe_date Date;
1484:

Line 1499: from ben_opt_f

1495: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1496:
1497: Cursor c_get_option_name is
1498: select name
1499: from ben_opt_f
1500: where opt_id = p_opt_id
1501: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1502:
1503: Cursor c_get_plan_name is