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 3802: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 3803: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 3804: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

Line 4528: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 4529: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 4530: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

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

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

Line 5489: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 5490: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 5491: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

Line 6798: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 6799: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 6800: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

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

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

Line 7627: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 7628: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 7629: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

Line 8433: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 8434: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

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

Line 8435: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

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

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

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

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

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

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

Line 9644: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

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

Line 10104: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

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

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

10336: NULL;
10337: --
10338: ELSE
10339: --
10340: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10341: --
10342: -- If cobra ineligible reason is null or if
10343: -- the reason code is Maximum Period of Enrollment reached.
10344: -- The cobra ineligible reason code is updated on the COBRA

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

10512: NULL;
10513: --
10514: ELSE
10515: --
10516: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10517: --
10518: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10519: ,p_person_id => p_person_id
10520: ,p_ler_id => l_der_rec.drvdlselg_id

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

10633: NULL;
10634: --
10635: ELSE
10636: --
10637: ben_seeddata_object.get_object(p_rec=> l_der_rec);
10638: --
10639: IF no_life_event(p_lf_evt_ocrd_dt=> l_lf_evt_ocrd_dt
10640: ,p_person_id => p_person_id
10641: ,p_ler_id => l_der_rec.drvdpoert_id