DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_SEEDDATA_OBJECT

Line 175: and ben_seeddata_object.

171: but if there is not one it uses
172: DOH.
173: 18-Jun-1999 G Perry 115.37 Performance fixes.
174: Added calls to ben_person_object
175: and ben_seeddata_object.
176: 23-Jun-1999 G Perry 115.38 Added calls to ben_env_object
177: so we no longer need g_last_pgm
178: _id.
179: 01-Jul-1999 maagrawa 115.39 Modified min_max_breach procedure

Line 3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
3806: l_effective_date DATE := NVL(p_lf_evt_ocrd_dt
3807: ,p_effective_date);

Line 3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
3806: l_effective_date DATE := NVL(p_lf_evt_ocrd_dt
3807: ,p_effective_date);
3808: l_dummy_date DATE;

Line 3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
3806: l_effective_date DATE := NVL(p_lf_evt_ocrd_dt
3807: ,p_effective_date);
3808: l_dummy_date DATE;
3809: l_rate BOOLEAN := FALSE;

Line 3965: ben_seeddata_object.get_object(p_rec=> l_der_rec);

3961: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,l_effective_date)
3962: ,p_rec => l_elig_rec);
3963: --
3964:
3965: ben_seeddata_object.get_object(p_rec=> l_der_rec);
3966: --
3967: min_max_breach
3968: (p_calculate_only_mode => p_calculate_only_mode
3969: ,p_comp_obj_tree_row => p_comp_obj_tree_row

Line 4158: ben_seeddata_object.get_object(p_rec=> l_der_rec);

4154: ,p_business_group_id => p_business_group_id
4155: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,l_effective_date)
4156: ,p_rec => l_rate_rec);
4157: --
4158: ben_seeddata_object.get_object(p_rec=> l_der_rec);
4159: --
4160: min_max_breach
4161: (p_calculate_only_mode => p_calculate_only_mode
4162: ,p_comp_obj_tree_row => p_comp_obj_tree_row

Line 4294: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

4290: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,
4291: l_effective_date)
4292: ,p_rec => l_rate_cvg_rec);
4293: --
4294: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
4295: --
4296: -- BUG: 3962514: Corrected the parameter below from l_rate_result to l_rate_cvg_rec
4297: min_max_breach
4298: (p_calculate_only_mode => p_calculate_only_mode

Line 4423: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

4419: ,p_old_val => p_comp_rec.rt_los_val
4420: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,l_effective_date)
4421: ,p_rec => l_rate_prem_rec);
4422: --
4423: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
4424: --
4425: min_max_breach
4426: (p_calculate_only_mode => p_calculate_only_mode
4427: ,p_comp_obj_tree_row => p_comp_obj_tree_row

Line 4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
4532: l_rate BOOLEAN := FALSE;
4533: l_cvg BOOLEAN := FALSE;

Line 4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
4532: l_rate BOOLEAN := FALSE;
4533: l_cvg BOOLEAN := FALSE;
4534: l_prem BOOLEAN := FALSE;

Line 4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
4532: l_rate BOOLEAN := FALSE;
4533: l_cvg BOOLEAN := FALSE;
4534: l_prem BOOLEAN := FALSE;
4535: l_age_val number;

Line 4659: ben_seeddata_object.get_object(p_rec=> l_der_rec);

4655: ,p_effective_date))
4656: ,p_rec => l_elig_rec);
4657: --
4658:
4659: ben_seeddata_object.get_object(p_rec=> l_der_rec);
4660: --
4661: -- IF l_elig_rec.age_to_use_cd = 'P'
4662: -- OR l_elig_rec.age_calc_rl IS NOT NULL THEN
4663: --

Line 4825: ben_seeddata_object.get_object(p_rec=> l_der_rec);

4821: --
4822: -- IF l_rate_rec.age_to_use_cd = 'P'
4823: -- OR l_elig_rec.age_calc_rl IS NOT NULL THEN
4824: --
4825: ben_seeddata_object.get_object(p_rec=> l_der_rec);
4826: --
4827: --hr_utility.set_location(' Step 12 ',10 );
4828: min_max_breach
4829: (p_calculate_only_mode => p_calculate_only_mode

Line 4926: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

4922: --
4923: -- IF l_rate_cvg_rec.age_to_use_cd = 'P'
4924: -- OR l_elig_rec.age_calc_rl IS NOT NULL THEN
4925: --
4926: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
4927: --
4928: --hr_utility.set_location(' Step 18' , 10);
4929: min_max_breach
4930: (p_calculate_only_mode => p_calculate_only_mode

Line 5021: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

5017: --
5018: -- IF l_rate_prem_rec.age_to_use_cd = 'P'
5019: -- OR l_elig_rec.age_calc_rl IS NOT NULL THEN
5020: --
5021: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
5022: --
5023: --hr_utility.set_location(' Step 22',10);
5024: min_max_breach
5025: (p_calculate_only_mode => p_calculate_only_mode

Line 5396: -- ben_seeddata_object.get_object(p_rec=> p_ler_id);

5392: end if;
5393: --
5394: IF l_lf_evt_ocrd_dt >= l_rec.min_ass_effective_start_date THEN
5395: --
5396: -- ben_seeddata_object.get_object(p_rec=> p_ler_id);
5397: --
5398: if g_debug then
5399: hr_utility.set_location(' Before no_life_event ',60);
5400: end if;

Line 5490: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5487: l_break VARCHAR2(30);
5488: l_ok BOOLEAN;
5489: l_rec ben_person_object.g_person_date_info_rec;
5490: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
5491: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
5492: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
5493: l_dummy_date DATE;
5494: l_start_date DATE;

Line 5491: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

5487: l_break VARCHAR2(30);
5488: l_ok BOOLEAN;
5489: l_rec ben_person_object.g_person_date_info_rec;
5490: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
5491: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
5492: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
5493: l_dummy_date DATE;
5494: l_start_date DATE;
5495: l_rate BOOLEAN := FALSE;

Line 5492: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

5488: l_ok BOOLEAN;
5489: l_rec ben_person_object.g_person_date_info_rec;
5490: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
5491: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
5492: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
5493: l_dummy_date DATE;
5494: l_start_date DATE;
5495: l_rate BOOLEAN := FALSE;
5496: l_cvg BOOLEAN := FALSE;

Line 5774: ben_seeddata_object.get_object(p_rec=> l_der_rec);

5770: END IF;
5771: --
5772: /* Bug 5478918 */
5773: --
5774: ben_seeddata_object.get_object(p_rec=> l_der_rec);
5775: if (skip_min_max_le_calc(l_der_rec.drvdcmp_id,
5776: p_business_group_id,
5777: p_ptnl_ler_trtmt_cd,
5778: p_effective_date)) THEN

Line 6242: ben_seeddata_object.get_object(p_rec=> l_der_rec);

6238: IF ( ben_whatif_elig.g_stat_comp IS NULL
6239: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
6240: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
6241: --
6242: ben_seeddata_object.get_object(p_rec=> l_der_rec);
6243: --
6244: if g_debug then
6245: hr_utility.set_location(' Call to comp_level_min_max ' ,45 );
6246: end if;

Line 6440: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

6436: IF ( ben_whatif_elig.g_stat_comp IS NULL
6437: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
6438: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
6439:
6440: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
6441: --
6442: if g_debug then
6443: hr_utility.set_location(' call comp_level_min_max ' ,75);
6444: end if;

Line 6644: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

6640: IF ( ben_whatif_elig.g_stat_comp IS NULL
6641: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
6642: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
6643: --
6644: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
6645: --
6646: if g_debug then
6647: hr_utility.set_location(' call to comp_level_min_max ' ,100);
6648: end if;

Line 6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
6802: l_rate BOOLEAN := FALSE;
6803: l_cvg BOOLEAN := FALSE;

Line 6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
6802: l_rate BOOLEAN := FALSE;
6803: l_cvg BOOLEAN := FALSE;
6804: l_prem BOOLEAN := FALSE;

Line 6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
6802: l_rate BOOLEAN := FALSE;
6803: l_cvg BOOLEAN := FALSE;
6804: l_prem BOOLEAN := FALSE;
6805: --

Line 6905: ben_seeddata_object.get_object(p_rec=> l_der_rec);

6901: IF p_comp_rec.cmbn_age_n_los_val IS NOT NULL THEN
6902: --
6903: --
6904: /* Bug 5478918 */
6905: ben_seeddata_object.get_object(p_rec=> l_der_rec);
6906: if (skip_min_max_le_calc(l_der_rec.drvdcal_id,
6907: p_business_group_id,
6908: p_ptnl_ler_trtmt_cd,
6909: p_effective_date)) THEN

Line 7089: ben_seeddata_object.get_object(p_rec=> l_der_rec);

7085: --
7086: IF p_comp_rec.rt_cmbn_age_n_los_val IS NOT NULL THEN
7087: --
7088: /* Bug 5478918 */
7089: ben_seeddata_object.get_object(p_rec=> l_der_rec);
7090: if (skip_min_max_le_calc(l_der_rec.drvdcal_id,
7091: p_business_group_id,
7092: p_ptnl_ler_trtmt_cd,
7093: p_effective_date)) THEN

Line 7230: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

7226: --
7227: IF p_comp_rec.rt_cmbn_age_n_los_val IS NOT NULL THEN
7228: --
7229: /* Bug 5478918 */
7230: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
7231: if (skip_min_max_le_calc(l_der_cvg_rec.drvdcal_id,
7232: p_business_group_id,
7233: p_ptnl_ler_trtmt_cd,
7234: p_effective_date)) THEN

Line 7370: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

7366: --
7367: IF p_comp_rec.rt_cmbn_age_n_los_val IS NOT NULL THEN
7368: --
7369: /* Bug 5478918 */
7370: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
7371: if (skip_min_max_le_calc(l_der_prem_rec.drvdcal_id,
7372: p_business_group_id,
7373: p_ptnl_ler_trtmt_cd,
7374: p_effective_date)) THEN

Line 7557: --ben_seeddata_object.get_object(p_rec=> l_der_rec);

7553: NULL;
7554: --
7555: ELSE
7556: --
7557: --ben_seeddata_object.get_object(p_rec=> l_der_rec);
7558: --
7559: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
7560: ,p_person_id => p_person_id
7561: ,p_ler_id => p_ler_id

Line 7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
7630: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
7631: l_ass_rec per_all_assignments_f%ROWTYPE;
7632: l_rate BOOLEAN := FALSE;

Line 7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
7630: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
7631: l_ass_rec per_all_assignments_f%ROWTYPE;
7632: l_rate BOOLEAN := FALSE;
7633: l_cvg BOOLEAN := FALSE;

Line 7630: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
7630: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
7631: l_ass_rec per_all_assignments_f%ROWTYPE;
7632: l_rate BOOLEAN := FALSE;
7633: l_cvg BOOLEAN := FALSE;
7634: l_prem BOOLEAN := FALSE;

Line 7721: ben_seeddata_object.get_object(p_rec=> l_der_rec);

7717: END IF;
7718: --
7719: /* Bug 5478918 */
7720: --
7721: ben_seeddata_object.get_object(p_rec=> l_der_rec);
7722: if (skip_min_max_le_calc(l_der_rec.drvdtpf_id,
7723: p_business_group_id,
7724: p_ptnl_ler_trtmt_cd,
7725: p_effective_date)) THEN

Line 7899: ben_seeddata_object.get_object(p_rec=> l_der_rec);

7895: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
7896: ,p_effective_date))
7897: ,p_rec => l_rate_rec);
7898: --
7899: ben_seeddata_object.get_object(p_rec=> l_der_rec);
7900: --
7901: percent_fulltime_min_max
7902: (p_calculate_only_mode =>p_calculate_only_mode
7903: ,p_comp_obj_tree_row =>p_comp_obj_tree_row

Line 7996: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

7992: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
7993: ,p_effective_date))
7994: ,p_rec => l_rate_cvg_rec);
7995: --
7996: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
7997: --
7998: percent_fulltime_min_max
7999: (p_calculate_only_mode =>p_calculate_only_mode
8000: ,p_comp_obj_tree_row =>p_comp_obj_tree_row

Line 8112: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

8108: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
8109: ,p_effective_date))
8110: ,p_rec => l_rate_prem_rec);
8111: --
8112: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
8113: --
8114: percent_fulltime_min_max
8115: (p_calculate_only_mode =>p_calculate_only_mode
8116: ,p_comp_obj_tree_row =>p_comp_obj_tree_row

Line 8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
8436: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
8437: l_dummy_date DATE;
8438: l_rate BOOLEAN := FALSE;

Line 8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
8436: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
8437: l_dummy_date DATE;
8438: l_rate BOOLEAN := FALSE;
8439: l_cvg BOOLEAN := FALSE;

Line 8436: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
8436: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
8437: l_dummy_date DATE;
8438: l_rate BOOLEAN := FALSE;
8439: l_cvg BOOLEAN := FALSE;
8440: l_prem BOOLEAN := FALSE;

Line 8592: ben_seeddata_object.get_object(p_rec=> l_der_rec);

8588: --hr_utility.set_location(' p_old_value '||p_comp_rec.hrs_wkd_val ,99);
8589: --hr_utility.set_location(' p_break '||l_break,99);
8590: --
8591: /* Bug 5478918 */
8592: ben_seeddata_object.get_object(p_rec=> l_der_rec);
8593: if (skip_min_max_le_calc(l_der_rec.drvdhrw_id,
8594: p_business_group_id,
8595: p_ptnl_ler_trtmt_cd,
8596: p_effective_date)) THEN

Line 8960: ben_seeddata_object.get_object(p_rec=> l_der_rec);

8956: --
8957: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL
8958: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
8959: --
8960: ben_seeddata_object.get_object(p_rec=> l_der_rec);
8961: --
8962: if g_debug then
8963: hr_utility.set_location(' Call to hours_worked_min_max ' ,45 );
8964: end if;

Line 9128: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);

9124: --
9125: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL
9126: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
9127: --
9128: ben_seeddata_object.get_object(p_rec=> l_der_cvg_rec);
9129: --
9130: if g_debug then
9131: hr_utility.set_location(' call hours_worked_min_max ' ,75);
9132: end if;

Line 9298: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);

9294: --
9295: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL
9296: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
9297: --
9298: ben_seeddata_object.get_object(p_rec=> l_der_prem_rec);
9299: --
9300: if g_debug then
9301: hr_utility.set_location(' call to comp_level_min_max ' ,100);
9302: end if;

Line 9645: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

9641: := g_package || '.determine_cobra_payments';
9642: l_lf_evt_ocrd_dt DATE;
9643: l_ok BOOLEAN;
9644: l_exists VARCHAR2(1);
9645: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
9646: l_rec ben_person_object.g_person_date_info_rec;
9647: l_due_date DATE;
9648: l_eff_due_date DATE;
9649: l_elcns_made_dt DATE;

Line 10053: ben_seeddata_object.get_object(p_rec=> l_der_rec);

10049: NULL;
10050: --
10051: ELSE
10052: --
10053: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10054: --
10055: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10056: ,p_person_id => p_person_id
10057: ,p_ler_id => l_der_rec.drvdnlp_id

Line 10105: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

10101: l_end_elig_date DATE;
10102: l_dsbld BOOLEAN := FALSE;
10103: l_ok BOOLEAN;
10104: l_exists VARCHAR2(1);
10105: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
10106: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;
10107: l_rec ben_person_object.g_person_date_info_rec;
10108: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
10109: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;

Line 10360: ben_seeddata_object.get_object(p_rec=> l_der_rec);

10356: NULL;
10357: --
10358: ELSE
10359: --
10360: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10361: --
10362: -- If cobra ineligible reason is null or if
10363: -- the reason code is Maximum Period of Enrollment reached.
10364: -- The cobra ineligible reason code is updated on the COBRA

Line 10536: ben_seeddata_object.get_object(p_rec=> l_der_rec);

10532: NULL;
10533: --
10534: ELSE
10535: --
10536: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10537: --
10538: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10539: ,p_person_id => p_person_id
10540: ,p_ler_id => l_der_rec.drvdlselg_id

Line 10657: ben_seeddata_object.get_object(p_rec=> l_der_rec);

10653: NULL;
10654: --
10655: ELSE
10656: --
10657: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10658: --
10659: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10660: ,p_person_id => p_person_id
10661: ,p_ler_id => l_der_rec.drvdpoert_id

Line 10716: ben_seeddata_object.get_object(p_rec=> l_der_rec);

10712: NULL;
10713: --
10714: ELSE
10715: --
10716: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10717: --
10718: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10719: ,p_person_id => p_person_id
10720: ,p_ler_id => l_der_rec.drvdpoert_id