[Home] [Help]
337: l_dummy varchar2(1);
338: --
339: cursor c1 is
340: select null
341: from ff_formulas_f ff ,
342: per_business_groups pbg
343: where ff.formula_id = p_dflt_enrt_det_rl
344: and ff.formula_type_id = -32 /*default enrollment det */
345: and pbg.business_group_id = p_business_group_id
433: l_dummy varchar2(1);
434: --
435: cursor c1 is
436: select null
437: from ff_formulas_f ff ,
438: per_business_groups pbg
439: where ff.formula_id = p_auto_enrt_mthd_rl
440: and ff.formula_type_id = -146 /*default enrollment det */
441: and pbg.business_group_id = p_business_group_id
681: l_dummy varchar2(1);
682: --
683: cursor c1 is
684: select null
685: from ff_formulas_f ff ,
686: per_business_groups pbg
687: where ff.formula_id = p_enrt_rl
688: and ff.formula_type_id = -393 /*default enrollment det */
689: and pbg.business_group_id = p_business_group_id
775: l_dummy varchar2(1);
776: --
777: cursor c1 is
778: select null
779: from ff_formulas_f ff ,
780: per_business_groups pbg
781: where ff.formula_id = p_dflt_to_asn_pndg_ctfn_rl
782: and ff.formula_type_id = -454
783: and pbg.business_group_id = p_business_group_id
871: l_dummy varchar2(1);
872: --
873: cursor c1 is
874: select null
875: from ff_formulas_f ff ,
876: per_business_groups pbg
877: where ff.formula_id = p_mn_cvg_rl
878: and ff.formula_type_id = -164
879: and pbg.business_group_id = p_business_group_id
967: l_dummy varchar2(1);
968: --
969: cursor c1 is
970: select null
971: from ff_formulas_f ff ,
972: per_business_groups pbg
973: where ff.formula_id = p_mx_cvg_rl
974: and ff.formula_type_id = -161
975: and pbg.business_group_id = p_business_group_id
1063: l_dummy varchar2(1);
1064: --
1065: cursor c1 is
1066: select null
1067: from ff_formulas_f ff ,
1068: per_business_groups pbg
1069: where ff.formula_id = p_prort_prtl_yr_cvg_rstrn_rl
1070: and ff.formula_type_id = -166
1071: and pbg.business_group_id = p_business_group_id
2929: l_dummy varchar2(1);
2930: --
2931: cursor c1 is
2932: select null
2933: from ff_formulas_f ff ,
2934: per_business_groups pbg
2935: where ff.formula_id = p_enrt_cvg_strt_dt_rl
2936: and ff.formula_type_id = -29
2937: and pbg.business_group_id = p_business_group_id
3022: l_dummy varchar2(1);
3023: --
3024: cursor c1 is
3025: select null
3026: from ff_formulas_f ff ,
3027: per_business_groups pbg
3028: where ff.formula_id = p_enrt_cvg_end_dt_rl
3029: and ff.formula_type_id = -30
3030: and pbg.business_group_id = p_business_group_id
3257: l_dummy varchar2(1);
3258: --
3259: cursor c1 is
3260: select null
3261: from ff_formulas_f ff ,
3262: per_business_groups pbg
3263: where ff.formula_id = p_rt_strt_dt_rl
3264: and ff.formula_type_id = -66
3265: and pbg.business_group_id = p_business_group_id
3423: l_dummy varchar2(1);
3424: --
3425: cursor c1 is
3426: select null
3427: from ff_formulas_f ff ,
3428: per_business_groups pbg
3429: where ff.formula_id = p_rt_end_dt_rl
3430: and ff.formula_type_id = -67
3431: and pbg.business_group_id = p_business_group_id
3518: l_dummy varchar2(1);
3519: --
3520: cursor c1 is
3521: select null
3522: from ff_formulas_f ff ,
3523: per_business_groups pbg
3524: where ff.formula_id = p_postelcn_edit_rl
3525: and ff.formula_type_id = -215
3526: and pbg.business_group_id = p_business_group_id
4260: p_argument_value => p_validation_end_date);
4261: --
4262: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4263: NOT (dt_api.check_min_max_dates
4264: (p_base_table_name => 'ff_formulas_f',
4265: p_base_key_column => 'formula_id',
4266: p_base_key_value => p_dflt_enrt_det_rl,
4267: p_from_date => p_validation_start_date,
4268: p_to_date => p_validation_end_date))) Then
4265: p_base_key_column => 'formula_id',
4266: p_base_key_value => p_dflt_enrt_det_rl,
4267: p_from_date => p_validation_start_date,
4268: p_to_date => p_validation_end_date))) Then
4269: l_table_name := 'ff_formulas_f';
4270: Raise l_integrity_error;
4271: End If;
4272: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4273: NOT (dt_api.check_min_max_dates