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_WHATIF_ELIG

Line 3112: IF ben_whatif_elig.g_bnft_bal_hwf_val IS NOT NULL THEN

3108: hr_utility.set_location('p_rec.hrs_src_cd '||p_rec.hrs_src_cd ,20);
3109: end if;
3110: IF p_rec.hrs_src_cd = 'BNFTBALTYP' THEN
3111: --
3112: IF ben_whatif_elig.g_bnft_bal_hwf_val IS NOT NULL THEN
3113: --
3114: -- This is the case where benmngle is called from the
3115: -- watif form and user wants to simulate hours worked
3116: -- changed. Use the user supplied simulate hours value rather

Line 3119: l_result := ben_whatif_elig.g_bnft_bal_hwf_val;

3115: -- watif form and user wants to simulate hours worked
3116: -- changed. Use the user supplied simulate hours value rather
3117: -- than the fetched value.
3118: --
3119: l_result := ben_whatif_elig.g_bnft_bal_hwf_val;
3120: --
3121: ELSE
3122: --
3123: -- Get the persons balance

Line 3217: IF ben_whatif_elig.g_bal_hwf_val IS NOT NULL THEN

3213: END IF; -- whatif hours worked existence check
3214: --
3215: ELSIF p_rec.hrs_src_cd = 'BALTYP' THEN
3216: --
3217: IF ben_whatif_elig.g_bal_hwf_val IS NOT NULL THEN
3218: --
3219: -- This is the case where benmngle is called from the
3220: -- watif form and user wants to simulate hours worked
3221: -- changed. Use the user supplied simulate hours value rather

Line 3224: l_result := ben_whatif_elig.g_bal_hwf_val;

3220: -- watif form and user wants to simulate hours worked
3221: -- changed. Use the user supplied simulate hours value rather
3222: -- than the fetched value.
3223: --
3224: l_result := ben_whatif_elig.g_bal_hwf_val;
3225: --
3226: ELSE
3227: --
3228: -- Get the persons balance

Line 3456: IF ben_whatif_elig.g_stat_comp IS NOT NULL THEN

3452: ,p_fonm_cvg_strt_dt => g_fonm_cvg_strt_dt);
3453: --
3454: IF p_rec.comp_src_cd = 'STTDCOMP' THEN
3455: --
3456: IF ben_whatif_elig.g_stat_comp IS NOT NULL THEN
3457: --
3458: -- This is the case where benmngle is called from the
3459: -- watif form and user wants to simulate compensation level
3460: -- changed. Use the user supplied compensation value rather

Line 3463: l_result := ben_whatif_elig.g_stat_comp;

3459: -- watif form and user wants to simulate compensation level
3460: -- changed. Use the user supplied compensation value rather
3461: -- than the fetched value.
3462: --
3463: l_result := ben_whatif_elig.g_stat_comp;
3464: --
3465: ELSE
3466: --
3467: -- Get the persons salary

Line 3540: IF ben_whatif_elig.g_bnft_bal_comp IS NOT NULL THEN

3536: END IF; -- whatif compensation existence check.
3537: --
3538: ELSIF p_rec.comp_src_cd = 'BNFTBALTYP' THEN
3539: --
3540: IF ben_whatif_elig.g_bnft_bal_comp IS NOT NULL THEN
3541: --
3542: -- This is the case where benmngle is called from the
3543: -- watif form and user wants to simulate compensation level
3544: -- changed. Use the user supplied compensation value rather

Line 3547: l_result := ben_whatif_elig.g_bnft_bal_comp;

3543: -- watif form and user wants to simulate compensation level
3544: -- changed. Use the user supplied compensation value rather
3545: -- than the fetched value.
3546: --
3547: l_result := ben_whatif_elig.g_bnft_bal_comp;
3548: --
3549: ELSE
3550: --
3551: -- Get the persons balance

Line 3625: IF ben_whatif_elig.g_bal_comp IS NOT NULL THEN

3621: END IF; -- whatif compensation existence check.
3622: --
3623: ELSIF p_rec.comp_src_cd = 'BALTYP' THEN
3624: --
3625: IF ben_whatif_elig.g_bal_comp IS NOT NULL THEN
3626: --
3627: -- This is the case where benmngle is called from the
3628: -- watif form and user wants to simulate compensation level
3629: -- changed. Use the user supplied compensation value rather

Line 3632: l_result := ben_whatif_elig.g_bal_comp;

3628: -- watif form and user wants to simulate compensation level
3629: -- changed. Use the user supplied compensation value rather
3630: -- than the fetched value.
3631: --
3632: l_result := ben_whatif_elig.g_bal_comp;
3633: --
3634: ELSE
3635: --
3636: -- Get the persons balance

Line 5791: ben_whatif_elig.g_stat_comp IS NULL

5787: -- temporals for any min, max breaches.
5788: --
5789: IF l_elig_result IS NOT NULL
5790: AND (
5791: ben_whatif_elig.g_stat_comp IS NULL
5792: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
5793: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
5794: --
5795: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id

Line 5792: AND ben_whatif_elig.g_bnft_bal_comp IS NULL

5788: --
5789: IF l_elig_result IS NOT NULL
5790: AND (
5791: ben_whatif_elig.g_stat_comp IS NULL
5792: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
5793: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
5794: --
5795: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id
5796: ,p_pl_id => p_pl_id

Line 5793: AND ben_whatif_elig.g_bal_comp IS NULL) THEN

5789: IF l_elig_result IS NOT NULL
5790: AND (
5791: ben_whatif_elig.g_stat_comp IS NULL
5792: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
5793: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
5794: --
5795: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id
5796: ,p_pl_id => p_pl_id
5797: ,p_oipl_id => p_oipl_id

Line 6238: IF ( ben_whatif_elig.g_stat_comp IS NULL

6234: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,
6235: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
6236: ,p_rec => l_rate_rec);
6237: --
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);

Line 6239: AND ben_whatif_elig.g_bnft_bal_comp IS NULL

6235: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
6236: ,p_rec => l_rate_rec);
6237: --
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: --

Line 6240: AND ben_whatif_elig.g_bal_comp IS NULL) THEN

6236: ,p_rec => l_rate_rec);
6237: --
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

Line 6281: END IF; -- ben_whatif_elig

6277: ,p_comp_src_cd =>l_rate_rec.comp_src_cd
6278: ,p_bnfts_bal_id =>l_rate_rec.bnfts_bal_id
6279: ) ;
6280: --
6281: END IF; -- ben_whatif_elig
6282: --
6283: END IF; -- l_rate_result
6284: --
6285: END IF; -- l_rate_rec.los_calc_rl

Line 6436: IF ( ben_whatif_elig.g_stat_comp IS NULL

6432: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
6433: ,p_rec => l_rate_cvg_rec);
6434:
6435: --
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);

Line 6437: AND ben_whatif_elig.g_bnft_bal_comp IS NULL

6433: ,p_rec => l_rate_cvg_rec);
6434:
6435: --
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: --

Line 6438: AND ben_whatif_elig.g_bal_comp IS NULL) THEN

6434:
6435: --
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

Line 6477: END IF; -- ben_whatif_elig

6473: ,p_lf_evt_ocrd_dt =>p_lf_evt_ocrd_dt
6474: ,p_comp_src_cd =>l_rate_cvg_rec.comp_src_cd
6475: ,p_bnfts_bal_id =>l_rate_cvg_rec.bnfts_bal_id
6476: ) ;
6477: END IF; -- ben_whatif_elig
6478: --
6479: END IF; -- l_rate_cvg_result
6480: --
6481: END IF; -- l_rate_cvg_rec.los_calc_rl

Line 6640: IF ( ben_whatif_elig.g_stat_comp IS NULL

6636: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,
6637: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
6638: ,p_rec => l_rate_prem_rec);
6639: --
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);

Line 6641: AND ben_whatif_elig.g_bnft_bal_comp IS NULL

6637: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
6638: ,p_rec => l_rate_prem_rec);
6639: --
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: --

Line 6642: AND ben_whatif_elig.g_bal_comp IS NULL) THEN

6638: ,p_rec => l_rate_prem_rec);
6639: --
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

Line 6682: END IF; --ben_whatif_elig

6678: ,p_comp_src_cd =>l_rate_prem_rec.comp_src_cd
6679: ,p_bnfts_bal_id =>l_rate_prem_rec.bnfts_bal_id
6680: ) ;
6681: --
6682: END IF; --ben_whatif_elig
6683: --
6684: END IF; -- l_rate_prem_result
6685: --
6686: END IF; -- l_rate_prem_rec.los_calc_rl

Line 8606: ben_whatif_elig.g_bal_hwf_val IS NULL

8602: else
8603: --
8604: IF l_elig_result IS NOT NULL
8605: AND (
8606: ben_whatif_elig.g_bal_hwf_val IS NULL
8607: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
8608: --
8609: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id
8610: ,p_pl_id => p_pl_id

Line 8607: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN

8603: --
8604: IF l_elig_result IS NOT NULL
8605: AND (
8606: ben_whatif_elig.g_bal_hwf_val IS NULL
8607: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
8608: --
8609: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id
8610: ,p_pl_id => p_pl_id
8611: ,p_oipl_id => p_oipl_id

Line 8957: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL

8953: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
8954: ,p_effective_date))
8955: ,p_rec => l_rate_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: --

Line 8958: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN

8954: ,p_effective_date))
8955: ,p_rec => l_rate_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

Line 8996: END IF; -- ben_whatif_elig

8992: ,p_hrs_src_cd =>l_rate_rec.hrs_src_cd
8993: ,p_bnfts_bal_id =>l_rate_rec.bnfts_bal_id
8994: ) ;
8995: --
8996: END IF; -- ben_whatif_elig
8997: --
8998: END IF; -- l_rate_result
8999: --
9000: END IF; -- l_rate_rec.los_calc_rl

Line 9125: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL

9121: ,p_effective_date))
9122: ,p_rec => l_rate_cvg_rec);
9123: --
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: --

Line 9126: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN

9122: ,p_rec => l_rate_cvg_rec);
9123: --
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

Line 9163: END IF; -- ben_whatif_elig

9159: ,p_lf_evt_ocrd_dt =>p_lf_evt_ocrd_dt
9160: ,p_hrs_src_cd =>l_rate_cvg_rec.hrs_src_cd
9161: ,p_bnfts_bal_id =>l_rate_cvg_rec.bnfts_bal_id
9162: ) ;
9163: END IF; -- ben_whatif_elig
9164: --
9165: END IF; -- l_rate_cvg_result
9166: --
9167: END IF; -- l_rate_cvg_rec.los_calc_rl

Line 9295: IF ( ben_whatif_elig.g_bal_hwf_val IS NULL

9291: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,
9292: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
9293: ,p_rec => l_rate_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: --

Line 9296: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN

9292: NVL(p_lf_evt_ocrd_dt ,p_effective_date))
9293: ,p_rec => l_rate_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

Line 9334: END IF; -- ben_whatif_elig

9330: ,p_lf_evt_ocrd_dt =>p_lf_evt_ocrd_dt
9331: ,p_hrs_src_cd =>l_rate_prem_rec.hrs_src_cd
9332: ,p_bnfts_bal_id =>l_rate_prem_rec.bnfts_bal_id
9333: ) ;
9334: END IF; -- ben_whatif_elig
9335: --
9336: END IF; -- l_rate_cvg_result
9337: --
9338: END IF; -- l_rate_prem_rec.los_calc_rl