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.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PERSON_OBJECT

Line 174: Added calls to ben_person_object

170: LOS Calculation now uses ASD
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.

Line 2054: l_rec ben_person_object.g_person_date_info_rec;

2050: l_det_cd VARCHAR2(30);
2051: l_lf_evt_ocrd_dt DATE;
2052: l_new_lf_evt_ocrd_dt DATE;
2053: l_start_date DATE;
2054: l_rec ben_person_object.g_person_date_info_rec;
2055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2056: --
2057: BEGIN
2058: --

Line 2204: ben_person_object.get_object(p_person_id=> p_person_id

2200: -- Bug 5731828.
2201: IF p_det_cd = 'ALDECLY' then
2202: l_new_lf_evt_ocrd_dt := trunc(l_new_lf_evt_ocrd_dt, 'YYYY');
2203: --
2204: ben_person_object.get_object(p_person_id=> p_person_id
2205: ,p_rec => l_rec);
2206: --
2207: -- If the person is hired after Jan 1, then set the occurred date
2208: -- to the effective start date.

Line 2240: ben_person_object.get_object(p_person_id=> p_person_id

2236: -- LOS - LED must be greater than min(effective_start_date) of person
2237: --
2238: IF l_new_lf_evt_ocrd_dt IS NOT NULL THEN
2239: --
2240: ben_person_object.get_object(p_person_id=> p_person_id
2241: ,p_rec => l_rec);
2242: --
2243: IF l_new_lf_evt_ocrd_dt < l_rec.min_per_effective_start_date THEN
2244: --

Line 2363: ben_person_object.get_object(p_person_id=> p_person_id

2359: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
2360: ,p_fonm_cvg_strt_dt => p_fonm_cvg_strt_dt
2361: );
2362: --
2363: ben_person_object.get_object(p_person_id=> p_person_id
2364: ,p_rec => l_pps_rec);
2365: --
2366: -- Bug 5392019 : For Date to use codes like 'Inherited%' use benefits assignment
2367: --

Line 2380: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

2376: -- hr_utility.set_location('get extra info',10);
2377: --
2378: -- Fix for 115.77
2379: --
2380: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
2381: ,p_rec => l_aei_rec);
2382: --
2383: END IF;
2384: --

Line 2387: ben_person_object.get_object(p_person_id=> p_person_id

2383: END IF;
2384: --
2385: IF p_rec.los_dt_to_use_cd = 'OHD' THEN
2386: -- Original hire date
2387: ben_person_object.get_object(p_person_id=> p_person_id
2388: ,p_rec => l_per_rec);
2389: --
2390: IF l_per_rec.original_date_of_hire IS NOT NULL THEN
2391: --

Line 2926: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

2922: l_ass_rec := p_benasg_row;
2923: --
2924: IF l_ass_rec.assignment_id IS NOT NULL THEN
2925: --
2926: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
2927: ,p_rec => l_aei_rec);
2928: --
2929: END IF;
2930: --

Line 2979: ben_person_object.get_object(p_person_id => l_person_id,

2975: --
2976: l_per_rec := p_per_row;
2977: --
2978: /*
2979: ben_person_object.get_object(p_person_id => l_person_id,
2980: p_rec => l_per_rec);
2981: --
2982: */
2983: --hr_utility.set_location(' Dn BPO_GO ' || l_package,10);

Line 3134: ben_person_object.get_object(p_person_id=> p_person_id

3130: if g_debug then
3131: hr_utility.set_location(' l_start_date '||l_start_date, 30);
3132: end if;
3133: --
3134: ben_person_object.get_object(p_person_id=> p_person_id
3135: ,p_effective_date => l_start_date
3136: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3137: ,p_rec => l_bal_rec);
3138: --

Line 3154: ben_person_object.get_object(p_person_id=> p_person_id

3150: if g_debug then
3151: hr_utility.set_location (' l_min_ass_date ' || l_min_ass_date, 1999);
3152: end if;
3153: if l_min_ass_date is not null then
3154: ben_person_object.get_object(p_person_id=> p_person_id
3155: ,p_effective_date => l_min_ass_date
3156: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3157: ,p_rec => l_bal_rec);
3158: --

Line 3175: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id

3171: -- Person does not have a balance, recheck if they have a balance
3172: -- as of the life event occurred date or effective date.
3173: -- Fix for bug 216.
3174: --
3175: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id
3176: ,p_rec => l_bnb_rec);
3177: --
3178: fnd_message.set_name('BEN'
3179: ,'BEN_92317_PER_BALANCE_NULL');

Line 3186: ben_person_object.get_object(p_person_id=> p_person_id

3182: fnd_message.set_token('DATE'
3183: ,l_start_date);
3184: benutils.write(p_text=> fnd_message.get);
3185: --
3186: ben_person_object.get_object(p_person_id=> p_person_id
3187: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
3188: ,p_effective_date))
3189: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3190: ,p_rec => l_bal_rec);

Line 3553: ben_person_object.get_object(p_person_id=> p_person_id

3549: ELSE
3550: --
3551: -- Get the persons balance
3552: --
3553: ben_person_object.get_object(p_person_id=> p_person_id
3554: ,p_effective_date => l_start_date
3555: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3556: ,p_rec => l_bal_rec);
3557: --

Line 3572: ben_person_object.get_object(p_person_id=> p_person_id

3568: if g_debug then
3569: hr_utility.set_location (' l_min_ass_date ' || l_min_ass_date, 1999);
3570: end if;
3571: if l_min_ass_date is not null then
3572: ben_person_object.get_object(p_person_id=> p_person_id
3573: ,p_effective_date => l_min_ass_date
3574: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3575: ,p_rec => l_bal_rec);
3576: --

Line 3586: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id

3582: -- Person does not have a balance, recheck if they have a balance
3583: -- as of the life event occurred date or effective date.
3584: -- Fix for bug 216.
3585: --
3586: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id
3587: ,p_rec => l_bnb_rec);
3588: --
3589: fnd_message.set_name('BEN'
3590: ,'BEN_92317_PER_BALANCE_NULL');

Line 3597: ben_person_object.get_object(p_person_id=> p_person_id

3593: fnd_message.set_token('DATE'
3594: ,l_start_date);
3595: benutils.write(p_text=> fnd_message.get);
3596: --
3597: ben_person_object.get_object(p_person_id=> p_person_id
3598: ,p_effective_date => p_effective_date
3599: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3600: ,p_rec => l_bal_rec);
3601: --

Line 5149: l_rec ben_person_object.g_person_date_info_rec;

5145: l_det_cd VARCHAR2(30);
5146: l_lf_evt_ocrd_dt DATE;
5147: l_new_lf_evt_ocrd_dt DATE;
5148: l_start_date DATE;
5149: l_rec ben_person_object.g_person_date_info_rec;
5150: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
5151: --
5152: BEGIN
5153: if g_debug then

Line 5384: ben_person_object.get_object(p_person_id=> p_person_id

5380: --
5381: -- Check if the calculated life event occured date breaks the
5382: -- min assignment date for the person.
5383: --
5384: ben_person_object.get_object(p_person_id=> p_person_id
5385: ,p_rec => l_rec);
5386: --
5387: if g_debug then
5388: hr_utility.set_location(' l_rec.min_ass_effective_start_date ' ||l_rec.min_ass_effective_start_date, 50);

Line 5489: l_rec ben_person_object.g_person_date_info_rec;

5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
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;

Line 5994: ben_person_object.get_object(p_person_id=> p_person_id

5990: --
5991: -- Check if the calculated life event occured date breaks the
5992: -- min assignment date for the person.
5993: --
5994: ben_person_object.get_object(p_person_id=> p_person_id
5995: ,p_rec => l_rec);
5996: --
5997: IF l_lf_evt_ocrd_dt >= l_rec.min_ass_effective_start_date THEN
5998: --

Line 7494: l_rec ben_person_object.g_person_date_info_rec;

7490: l_det_cd VARCHAR2(30);
7491: l_lf_evt_ocrd_dt DATE;
7492: l_new_lf_evt_ocrd_dt DATE;
7493: l_start_date DATE;
7494: l_rec ben_person_object.g_person_date_info_rec;
7495: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
7496: --
7497: BEGIN
7498: if g_debug then

Line 7627: l_rec ben_person_object.g_person_fte_info_rec;

7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
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;

Line 7690: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

7686: -- Check if any assignment exists
7687: --
7688: IF l_ass_rec.assignment_id IS NOT NULL THEN
7689: --
7690: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
7691: ,p_rec => l_rec);
7692: --
7693: IF l_elig_rec.use_prmry_asnt_only_flag = 'Y' THEN
7694: --

Line 7855: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

7851: l_ass_rec := p_empasg_row;
7852: --
7853: END IF;
7854: --
7855: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
7856: ,p_rec => l_rec);
7857:
7858: IF l_rate_rec.use_prmry_asnt_only_flag = 'Y' THEN
7859: --

Line 7957: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

7953: l_ass_rec := p_empasg_row;
7954: --
7955: END IF;
7956: --
7957: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
7958: ,p_rec => l_rec);
7959:
7960: IF l_rate_cvg_rec.use_prmry_asnt_only_flag = 'Y' THEN
7961: --

Line 8065: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id

8061:
8062: if g_debug then
8063: hr_utility.set_location(' l_ass_rec.assignment_id '||l_ass_rec.assignment_id, 30);
8064: end if;
8065: ben_person_object.get_object(p_assignment_id=> l_ass_rec.assignment_id
8066: ,p_rec => l_rec);
8067:
8068: IF l_rate_prem_rec.use_prmry_asnt_only_flag = 'Y' THEN
8069: --

Line 8221: l_rec ben_person_object.g_person_date_info_rec;

8217: l_det_cd VARCHAR2(30);
8218: l_lf_evt_ocrd_dt DATE;
8219: l_new_lf_evt_ocrd_dt DATE;
8220: l_start_date DATE;
8221: l_rec ben_person_object.g_person_date_info_rec;
8222: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
8223: --
8224: BEGIN
8225: hr_utility.set_location('Entering hours_worked_min_max ', 10 );

Line 8354: ben_person_object.get_object(p_person_id=> p_person_id

8350: --
8351: -- Life event occured date must be less than the minimum
8352: -- assignment effective start date
8353: --
8354: ben_person_object.get_object(p_person_id=> p_person_id
8355: ,p_rec => l_rec);
8356: --
8357: IF l_lf_evt_ocrd_dt >= l_rec.min_ass_effective_start_date THEN
8358: --

Line 8433: l_rec ben_person_object.g_person_date_info_rec;

8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
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;

Line 8731: ben_person_object.get_object(p_person_id=> p_person_id

8727: --
8728: -- Life event occured date must be less than the minimum
8729: -- assignment effective start date
8730: --
8731: ben_person_object.get_object(p_person_id=> p_person_id
8732: ,p_rec => l_rec);
8733: --
8734: IF l_lf_evt_ocrd_dt >= l_rec.min_ass_effective_start_date THEN
8735: --

Line 9646: l_rec ben_person_object.g_person_date_info_rec;

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;
9650: l_pymt_amt number;

Line 9797: ben_person_object.get_object(p_person_id=> p_person_id

9793: --
9794: -- If the person has not made a payment within the a grace period
9795: -- generate a late or non-payment life event.
9796: --
9797: ben_person_object.get_object(p_person_id=> p_person_id
9798: ,p_rec => l_rec);
9799: --
9800: -- Check if the person is late with his/her payment.
9801: --

Line 10107: l_rec ben_person_object.g_person_date_info_rec;

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;
10110: l_effective_date DATE;
10111: l_due_date DATE;

Line 10326: ben_person_object.get_object(p_person_id=> p_person_id

10322: -- the rates. For disablity, the rates for the extended period can
10323: -- be 150% of premium as opposed to 102% of premium for the first 18
10324: -- months. This is at the discretion of the employer.
10325: --
10326: ben_person_object.get_object(p_person_id=> p_person_id
10327: ,p_rec => l_rec);
10328: --
10329: OPEN c_get_cbr_elig_dates;
10330: FETCH c_get_cbr_elig_dates INTO l_cqb_rec;