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_EXT_EVALUATE_INCLUSION dependencies on BEN_EXTRACT

Line 1555: p_abs_date => ben_extract.g_effective_date,

1551: ---intilise the gloabl variable
1552: if g_payroll_last_dt_list1.count > 0 and g_payroll_last_dt_list2.count > 0 then
1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date
1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),

Line 1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

1552: if g_payroll_last_dt_list1.count > 0 and g_payroll_last_dt_list2.count > 0 then
1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date
1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),
1560: p_abs_date => ben_extract.g_effective_date,

Line 1560: p_abs_date => ben_extract.g_effective_date,

1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),
1560: p_abs_date => ben_extract.g_effective_date,
1561: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1562:
1563: end if ;
1564:

Line 1561: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),
1560: p_abs_date => ben_extract.g_effective_date,
1561: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1562:
1563: end if ;
1564:
1565: elsif l_crit_typ_cd = 'PASU' then --person assignment to use

Line 2340: ,p_param3_value => to_char(ben_extract.g_proc_business_group_id)

2336: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
2337: ,p_param2 => 'EXT_RSLT_ID'
2338: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
2339: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
2340: ,p_param3_value => to_char(ben_extract.g_proc_business_group_id)
2341: );
2342: if l_outputs(l_outputs.first).value = 'Y' then
2343: if p_excld_flag = 'N' then
2344: raise g_include;

Line 2832: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

2828: loop
2829: l_low_date := ben_ext_util.calc_ext_date
2830: (p_ext_date_cd => g_enrt_cvg_strt_dt_list1(i),
2831: p_abs_date => p_effective_date,
2832: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2833: p_pl_id => p_pl_id);
2834: l_high_date := ben_ext_util.calc_ext_date
2835: (p_ext_date_cd => g_enrt_cvg_strt_dt_list2(i),
2836: p_abs_date => p_effective_date,

Line 2837: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

2833: p_pl_id => p_pl_id);
2834: l_high_date := ben_ext_util.calc_ext_date
2835: (p_ext_date_cd => g_enrt_cvg_strt_dt_list2(i),
2836: p_abs_date => p_effective_date,
2837: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2838: p_pl_id => p_pl_id
2839: );
2840: if p_enrt_cvg_strt_dt between l_low_date and nvl(l_high_date,l_low_date) then
2841: if p_excld_flag = 'N' then

Line 2899: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

2895: loop
2896: l_low_date := ben_ext_util.calc_ext_date
2897: (p_ext_date_cd => g_enrt_cvg_drng_perd_list1(i),
2898: p_abs_date => p_effective_date,
2899: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2900: p_pl_id => p_pl_id );
2901: l_high_date := ben_ext_util.calc_ext_date
2902: (p_ext_date_cd => g_enrt_cvg_drng_perd_list2(i),
2903: p_abs_date => p_effective_date,

Line 2904: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

2900: p_pl_id => p_pl_id );
2901: l_high_date := ben_ext_util.calc_ext_date
2902: (p_ext_date_cd => g_enrt_cvg_drng_perd_list2(i),
2903: p_abs_date => p_effective_date,
2904: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2905: p_pl_id => p_pl_id );
2906: l_high_date := nvl(l_high_date,l_low_date);
2907: -- out of range if both dates are less than low date or greater than high date.
2908: if (p_enrt_cvg_strt_dt < l_low_date and p_enrt_cvg_thru_dt < l_low_date) or

Line 3177: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3173: loop
3174: l_low_date := ben_ext_util.calc_ext_date
3175: (p_ext_date_cd => g_enrt_last_upd_dt_list1(i),
3176: p_abs_date => p_effective_date,
3177: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3178: p_pl_id => p_pl_id );
3179:
3180: l_high_date := ben_ext_util.calc_ext_date
3181: (p_ext_date_cd => g_enrt_last_upd_dt_list2(i),

Line 3183: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3179:
3180: l_high_date := ben_ext_util.calc_ext_date
3181: (p_ext_date_cd => g_enrt_last_upd_dt_list2(i),
3182: p_abs_date => p_effective_date,
3183: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3184: p_pl_id => p_pl_id );
3185:
3186: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
3187: if p_excld_flag = 'N' then

Line 3343: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3339: loop
3340: l_low_date := ben_ext_util.calc_ext_date
3341: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list1(i),
3342: p_abs_date => p_effective_date,
3343: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3344: p_pl_id => p_pl_id );
3345: l_high_date := ben_ext_util.calc_ext_date
3346: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list2(i),
3347: p_abs_date => p_effective_date,

Line 3348: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

3344: p_pl_id => p_pl_id );
3345: l_high_date := ben_ext_util.calc_ext_date
3346: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list2(i),
3347: p_abs_date => p_effective_date,
3348: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3349: p_pl_id => p_pl_id );
3350: if p_lf_evt_ocrd_dt between l_low_date and nvl(l_high_date,l_low_date) then
3351: if p_excld_flag = 'N' then
3352: raise g_include;

Line 3407: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

3403: loop
3404: l_low_date := ben_ext_util.calc_ext_date
3405: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list1(i),
3406: p_abs_date => p_effective_date,
3407: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
3408: l_high_date := ben_ext_util.calc_ext_date
3409: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list2(i),
3410: p_abs_date => p_effective_date,
3411: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

Line 3411: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3407: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
3408: l_high_date := ben_ext_util.calc_ext_date
3409: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list2(i),
3410: p_abs_date => p_effective_date,
3411: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3412: p_pl_id => p_pl_id );
3413: if p_ntfn_dt between l_low_date and nvl(l_high_date,l_low_date) then
3414: if p_excld_flag = 'N' then
3415: raise g_include;

Line 3799: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

3795: loop
3796: l_low_date := ben_ext_util.calc_ext_date
3797: (p_ext_date_cd => g_elct_enrt_strt_dt_list1(i),
3798: p_abs_date => p_effective_date,
3799: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3800: p_pl_id => p_pl_id );
3801: l_high_date := ben_ext_util.calc_ext_date
3802: (p_ext_date_cd => g_elct_enrt_strt_dt_list2(i),
3803: p_abs_date => p_effective_date,

Line 3804: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3800: p_pl_id => p_pl_id );
3801: l_high_date := ben_ext_util.calc_ext_date
3802: (p_ext_date_cd => g_elct_enrt_strt_dt_list2(i),
3803: p_abs_date => p_effective_date,
3804: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3805: p_pl_id => p_pl_id );
3806: if p_elct_enrt_strt_dt between l_low_date and nvl(l_high_date,l_low_date) then
3807: if p_excld_flag = 'N' then
3808: raise g_include;

Line 3965: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

3961: loop
3962: l_low_date := ben_ext_util.calc_ext_date
3963: (p_ext_date_cd => g_elct_last_upd_dt_list1(i),
3964: p_abs_date => p_effective_date,
3965: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3966: p_pl_id => p_pl_id );
3967: l_high_date := ben_ext_util.calc_ext_date
3968: (p_ext_date_cd => g_elct_last_upd_dt_list2(i),
3969: p_abs_date => p_effective_date,

Line 3970: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

3966: p_pl_id => p_pl_id );
3967: l_high_date := ben_ext_util.calc_ext_date
3968: (p_ext_date_cd => g_elct_last_upd_dt_list2(i),
3969: p_abs_date => p_effective_date,
3970: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3971: p_pl_id => p_pl_id );
3972: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
3973: if p_excld_flag = 'N' then
3974: raise g_include;

Line 4182: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

4178: loop
4179: l_low_date := ben_ext_util.calc_ext_date
4180: (p_ext_date_cd => g_elct_ler_ocrd_dt_list1(i),
4181: p_abs_date => p_effective_date,
4182: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
4183: p_pl_id => p_pl_id );
4184: l_high_date := ben_ext_util.calc_ext_date
4185: (p_ext_date_cd => g_elct_ler_ocrd_dt_list2(i),
4186: p_abs_date => p_effective_date,

Line 4187: p_ext_dfn_id => ben_extract.g_ext_dfn_id,

4183: p_pl_id => p_pl_id );
4184: l_high_date := ben_ext_util.calc_ext_date
4185: (p_ext_date_cd => g_elct_ler_ocrd_dt_list2(i),
4186: p_abs_date => p_effective_date,
4187: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
4188: p_pl_id => p_pl_id );
4189: if p_lf_evt_ocrd_dt between l_low_date and nvl(l_high_date,l_low_date) then
4190: if p_excld_flag = 'N' then
4191: raise g_include;

Line 4247: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

4243: loop
4244: l_low_date := ben_ext_util.calc_ext_date
4245: (p_ext_date_cd => g_elct_ler_ntfn_dt_list1(i),
4246: p_abs_date => p_effective_date,
4247: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
4248: p_pl_id => p_pl_id );
4249: l_high_date := ben_ext_util.calc_ext_date
4250: (p_ext_date_cd => g_elct_ler_ntfn_dt_list2(i),
4251: p_abs_date => p_effective_date,

Line 4252: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,

4248: p_pl_id => p_pl_id );
4249: l_high_date := ben_ext_util.calc_ext_date
4250: (p_ext_date_cd => g_elct_ler_ntfn_dt_list2(i),
4251: p_abs_date => p_effective_date,
4252: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
4253: p_pl_id => p_pl_id );
4254: if p_ntfn_dt between l_low_date and nvl(l_high_date,l_low_date) then
4255: if p_excld_flag = 'N' then
4256: raise g_include;

Line 4441: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4437: else
4438: l_low_date := ben_ext_util.calc_ext_date
4439: (p_ext_date_cd => g_chg_eff_dt_list1(i),
4440: p_abs_date => p_effective_date,
4441: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4442: l_high_date := ben_ext_util.calc_ext_date
4443: (p_ext_date_cd => g_chg_eff_dt_list2(i),
4444: p_abs_date => p_effective_date,
4445: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4445: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4441: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4442: l_high_date := ben_ext_util.calc_ext_date
4443: (p_ext_date_cd => g_chg_eff_dt_list2(i),
4444: p_abs_date => p_effective_date,
4445: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4446: end if ;
4447: ---
4448: if p_chg_eff_dt between l_low_date and nvl(l_high_date,l_low_date) then
4449: if p_excld_flag = 'N' then

Line 4511: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4507: else
4508: l_low_date := ben_ext_util.calc_ext_date
4509: (p_ext_date_cd => g_chg_actl_dt_list1(i),
4510: p_abs_date => p_effective_date,
4511: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4512: l_high_date := ben_ext_util.calc_ext_date
4513: (p_ext_date_cd => g_chg_actl_dt_list2(i),
4514: p_abs_date => p_effective_date,
4515: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4515: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4511: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4512: l_high_date := ben_ext_util.calc_ext_date
4513: (p_ext_date_cd => g_chg_actl_dt_list2(i),
4514: p_abs_date => p_effective_date,
4515: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4516: end if ;
4517: if p_chg_actl_dt between l_low_date and nvl(l_high_date,l_low_date) then
4518: if p_excld_flag = 'N' then
4519: raise g_include;

Line 4673: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4669: loop
4670: l_low_date := ben_ext_util.calc_ext_date
4671: (p_ext_date_cd => g_cm_last_upd_dt_list1(i),
4672: p_abs_date => p_effective_date,
4673: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4674: l_high_date := ben_ext_util.calc_ext_date
4675: (p_ext_date_cd => g_cm_last_upd_dt_list2(i),
4676: p_abs_date => p_effective_date,
4677: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4677: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4673: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4674: l_high_date := ben_ext_util.calc_ext_date
4675: (p_ext_date_cd => g_cm_last_upd_dt_list2(i),
4676: p_abs_date => p_effective_date,
4677: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4678: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4679: if p_excld_flag = 'N' then
4680: raise g_include;
4681: else

Line 4734: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4730: loop
4731: l_low_date := ben_ext_util.calc_ext_date
4732: (p_ext_date_cd => g_cm_pr_last_upd_dt_list1(i),
4733: p_abs_date => p_effective_date,
4734: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4735: l_high_date := ben_ext_util.calc_ext_date
4736: (p_ext_date_cd => g_cm_pr_last_upd_dt_list2(i),
4737: p_abs_date => p_effective_date,
4738: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4738: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4734: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4735: l_high_date := ben_ext_util.calc_ext_date
4736: (p_ext_date_cd => g_cm_pr_last_upd_dt_list2(i),
4737: p_abs_date => p_effective_date,
4738: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4739: if p_pvdd_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then
4740: if p_excld_flag = 'N' then
4741: raise g_include;
4742: else

Line 4797: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4793:
4794: l_low_date := ben_ext_util.calc_ext_date
4795: (p_ext_date_cd => g_payroll_last_dt_list1(i),
4796: p_abs_date => p_effective_date,
4797: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4798:
4799: l_high_date := ben_ext_util.calc_ext_date
4800: (p_ext_date_cd => g_payroll_last_dt_list2(i),
4801: p_abs_date => p_effective_date,

Line 4802: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4798:
4799: l_high_date := ben_ext_util.calc_ext_date
4800: (p_ext_date_cd => g_payroll_last_dt_list2(i),
4801: p_abs_date => p_effective_date,
4802: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4803: if g_debug then
4804: hr_utility.set_location(' hight date '|| l_high_date,51);
4805: hr_utility.set_location(' low date ' || l_low_date,51);
4806: end if;

Line 4877: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4873: loop
4874: l_low_date := ben_ext_util.calc_ext_date
4875: (p_ext_date_cd => g_prem_last_upd_dt_list1(i),
4876: p_abs_date => p_effective_date,
4877: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4878: l_high_date := ben_ext_util.calc_ext_date
4879: (p_ext_date_cd => g_prem_last_upd_dt_list2(i),
4880: p_abs_date => p_effective_date,
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4877: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4878: l_high_date := ben_ext_util.calc_ext_date
4879: (p_ext_date_cd => g_prem_last_upd_dt_list2(i),
4880: p_abs_date => p_effective_date,
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4882: if g_debug then
4883: hr_utility.set_location(' hight date '|| l_high_date,16);
4884: hr_utility.set_location(' low date ' || l_low_date,16);
4885: hr_utility.set_location(' update dte '|| p_last_update_date,16);

Line 4959: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4955: loop
4956: l_low_date := ben_ext_util.calc_ext_date
4957: (p_ext_date_cd => g_prem_month_year_dt_list1(i),
4958: p_abs_date => p_effective_date,
4959: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4960: l_high_date := ben_ext_util.calc_ext_date
4961: (p_ext_date_cd => g_prem_month_year_dt_list2(i),
4962: p_abs_date => p_effective_date,
4963: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 4963: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

4959: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4960: l_high_date := ben_ext_util.calc_ext_date
4961: (p_ext_date_cd => g_prem_month_year_dt_list2(i),
4962: p_abs_date => p_effective_date,
4963: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4964: ---converting to month no and year no
4965: l_low_mo_no := to_number(to_char(l_low_date,'MM')) ;
4966: l_low_yr_no := to_number(to_char(l_low_date,'RRRR')) ;
4967:

Line 5040: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

5036: loop
5037: l_low_date := ben_ext_util.calc_ext_date
5038: (p_ext_date_cd => g_cm_sent_dt_list1(i),
5039: p_abs_date => p_effective_date,
5040: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5041: l_high_date := ben_ext_util.calc_ext_date
5042: (p_ext_date_cd => g_cm_sent_dt_list2(i),
5043: p_abs_date => p_effective_date,
5044: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 5044: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

5040: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5041: l_high_date := ben_ext_util.calc_ext_date
5042: (p_ext_date_cd => g_cm_sent_dt_list2(i),
5043: p_abs_date => p_effective_date,
5044: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5045: if p_sent_dt between l_low_date and nvl(l_high_date,l_low_date) then
5046: if p_excld_flag = 'N' then
5047: raise g_include;
5048: else

Line 5101: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

5097: loop
5098: l_low_date := ben_ext_util.calc_ext_date
5099: (p_ext_date_cd => g_cm_to_be_sent_dt_list1(i),
5100: p_abs_date => p_effective_date,
5101: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5102: l_high_date := ben_ext_util.calc_ext_date
5103: (p_ext_date_cd => g_cm_to_be_sent_dt_list2(i),
5104: p_abs_date => p_effective_date,
5105: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

Line 5105: p_ext_dfn_id => ben_extract.g_ext_dfn_id);

5101: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5102: l_high_date := ben_ext_util.calc_ext_date
5103: (p_ext_date_cd => g_cm_to_be_sent_dt_list2(i),
5104: p_abs_date => p_effective_date,
5105: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5106: if p_to_be_sent_dt between l_low_date and nvl(l_high_date,l_low_date) then
5107: if p_excld_flag = 'N' then
5108: raise g_include;
5109: else

Line 6004: ,p_param5_value => to_char(ben_extract.g_proc_business_group_id)

6000: ,p_param3_value => p_param_val_1
6001: ,p_param4 => p_param_2
6002: ,p_param4_value => p_param_val_2
6003: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
6004: ,p_param5_value => to_char(ben_extract.g_proc_business_group_id)
6005: );
6006: hr_utility.set_location(' out of rl :'||l_outputs(l_outputs.first).value , 5);
6007: if l_outputs(l_outputs.first).value = 'Y' then
6008: if p_excld_flag = 'N' then

Line 6113: ,p_param9_value => to_char(ben_extract.g_proc_business_group_id)

6109: ,p_param7_value => p_source_type
6110: ,p_param8 => 'EXT_PAY_ELEMENT_ENTRY'
6111: ,p_param8_value => to_char(p_element_entry_id )
6112: ,p_param9 => 'EXT_PROCESS_BUSINESS_GROUP'
6113: ,p_param9_value => to_char(ben_extract.g_proc_business_group_id)
6114: );
6115: hr_utility.set_location(' out of rl :'||l_outputs(l_outputs.first).value , 5);
6116: if l_outputs(l_outputs.first).value = 'Y' then
6117: if p_excld_flag = 'N' then