APPS.BEN_EVALUATE_RATE_PROFILES dependencies on HR_API

Line 28: l_const varchar2(50) := hr_api.g_varchar2;

24: l_ok boolean := false;
25: l_rows_found boolean := false;
26: l_seg_ok boolean := true;
27: --
28: l_const varchar2(50) := hr_api.g_varchar2;
29: --
30: cursor c_ppl_grp is
31: select ppg.people_group_id , ppg.segment1 ,ppg.segment2 ,ppg.segment3 ,ppg.segment4 ,
32: ppg.segment5 , ppg.segment6 ,ppg.segment7 ,ppg.segment8 ,ppg.segment9 , ppg.segment10 ,

Line 3081: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)

3077: -- possible NULL return instead of expected TRUE or FALSE
3078: -- Bug 9033589: Commented the if condition below
3079: /*
3080: if not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
3081: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)
3082: then
3083: */
3084: --
3085: ben_derive_factors.determine_age

Line 3503: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)

3499: -- possible NULL return instead of expected TRUE or FALSE
3500: -- Bug 9033589: Commented the if condition below
3501: /*
3502: if not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
3503: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)
3504: then
3505: */
3506: --
3507: ben_derive_factors.determine_los

Line 3719: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)

3715: -- possible NULL return instead of expected TRUE or FALSE
3716: -- Bug 9033589: Commented the below condition
3717: /*
3718: if not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
3719: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > p_effective_date)
3720: then
3721: */
3722: --BBULUSU - changed determine_los to determine_comb_age_los below
3723: ben_derive_factors.determine_comb_age_los

Line 3966: l_strt_dt := hr_api.g_sot;

3962: ,p_max => l_mn_poe_num
3963: ,p_value => null
3964: )) + 1;
3965: else
3966: l_strt_dt := hr_api.g_sot;
3967: end if;
3968: --
3969: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 199);
3970: -- Calculate the end date.

Line 3981: l_end_dt := hr_api.g_eot;

3977: ,p_max => l_inst_set(i).mx_poe_num
3978: ,p_value => null
3979: );
3980: else
3981: l_end_dt := hr_api.g_eot;
3982: end if;
3983: --
3984: hr_utility.set_location ('l_end_dt '||l_end_dt , 199);
3985: --

Line 4026: l_strt_dt := hr_api.g_sot;

4022: ,p_value => null
4023: ));
4024: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 200);
4025: else
4026: l_strt_dt := hr_api.g_sot;
4027: end if;
4028: --
4029: -- Calculate the end date.
4030: --

Line 4040: l_end_dt := hr_api.g_eot;

4036: ,p_max => l_inst_set(i).mx_poe_num
4037: ,p_value => null
4038: );
4039: else
4040: l_end_dt := hr_api.g_eot;
4041: end if;
4042: --
4043: -- Disability rates applies if:
4044: -- 1) if the last qualifying event that the person experienced

Line 4543: and pdp.effective_end_date = hr_api.g_eot;

4539: and pen.prtt_enrt_rslt_stat_cd is null
4540: and l_date_to_use
4541: between pdp.cvg_strt_dt
4542: and pdp.cvg_thru_dt
4543: and pdp.effective_end_date = hr_api.g_eot;
4544:
4545: begin
4546: --
4547: hr_utility.set_location('Entering : '||l_proc,10);

Line 4658: and pdp.effective_end_date = hr_api.g_eot;

4654: and pdp.business_group_id = pen.business_group_id
4655: and l_date_to_use
4656: between pdp.cvg_strt_dt
4657: and pdp.cvg_thru_dt
4658: and pdp.effective_end_date = hr_api.g_eot;
4659: begin
4660: --
4661: hr_utility.set_location('Entering : '||l_proc,10);
4662: --

Line 4767: and pdp.effective_end_date = hr_api.g_eot;

4763: and pdp.business_group_id = pen.business_group_id
4764: and l_date_to_use
4765: between pdp.cvg_strt_dt
4766: and pdp.cvg_thru_dt
4767: and pdp.effective_end_date = hr_api.g_eot;
4768: --
4769: cursor c2(p_pl_id in number) is
4770: select null
4771: from ben_pl_regn_f prg

Line 4905: and pdp.effective_end_date = hr_api.g_eot;

4901: and pen.prtt_enrt_rslt_stat_cd is null
4902: and l_date_to_use
4903: between pdp.cvg_strt_dt
4904: and pdp.cvg_thru_dt
4905: and pdp.effective_end_date = hr_api.g_eot;
4906:
4907:
4908: begin
4909: --