DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_HASH_UTILITY

Line 171: g_hash_key number := ben_hash_utility.get_hash_key;

167: --
168: --
169: g_package varchar2(80) := 'ben_distribute_rates';
170: --
171: g_hash_key number := ben_hash_utility.get_hash_key;
172: g_hash_jump number := ben_hash_utility.get_hash_jump;
173: --
174: -- Function cache stuff
175: --

Line 172: g_hash_jump number := ben_hash_utility.get_hash_jump;

168: --
169: g_package varchar2(80) := 'ben_distribute_rates';
170: --
171: g_hash_key number := ben_hash_utility.get_hash_key;
172: g_hash_jump number := ben_hash_utility.get_hash_jump;
173: --
174: -- Function cache stuff
175: --
176: type g_period_to_annual_row is record

Line 2632: ,ben_hash_utility.get_hash_key);

2628: +nvl(p_start_date-hr_api.g_sot,4)
2629: +nvl(p_end_date-hr_api.g_sot,5)
2630: +nvl(p_payroll_id,6)
2631: +nvl(p_element_type_id,7)
2632: ,ben_hash_utility.get_hash_key);
2633: --
2634: if nvl(g_period_to_annual_cache(l_hv).amount,-1) = nvl(p_amount,-1)
2635: and nvl(g_period_to_annual_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
2636: and nvl(g_period_to_annual_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 2798: ,ben_hash_utility.get_hash_key);

2794: +nvl(p_start_date-hr_api.g_sot,4)
2795: +nvl(p_end_date-hr_api.g_sot,5)
2796: +nvl(p_payroll_id,6)
2797: +nvl(p_element_type_id,7)
2798: ,ben_hash_utility.get_hash_key);
2799: --
2800: while g_period_to_annual_cache.exists(l_hv)
2801: loop
2802: --

Line 2917: ,ben_hash_utility.get_hash_key);

2913: +nvl(p_start_date-hr_api.g_sot,4)
2914: +nvl(p_end_date-hr_api.g_sot,5)
2915: +nvl(p_payroll_id,6)
2916: +nvl(p_element_type_id,7)
2917: ,ben_hash_utility.get_hash_key);
2918: --
2919: if nvl(g_period_to_annual_cache(l_hv).amount,-1) = nvl(p_amount,-1)
2920: and nvl(g_period_to_annual_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
2921: and nvl(g_period_to_annual_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 3087: ,ben_hash_utility.get_hash_key);

3083: +nvl(p_start_date-hr_api.g_sot,4)
3084: +nvl(p_end_date-hr_api.g_sot,5)
3085: +nvl(p_payroll_id,6)
3086: +nvl(p_element_type_id,7)
3087: ,ben_hash_utility.get_hash_key);
3088: --
3089: while g_period_to_annual_cache.exists(l_hv)
3090: loop
3091: --

Line 3242: ,ben_hash_utility.get_hash_key);

3238: +nvl(p_start_date-hr_api.g_sot,4)
3239: +nvl(p_end_date-hr_api.g_sot,5)
3240: +nvl(p_payroll_id,6)
3241: +nvl(p_element_type_id,7)
3242: ,ben_hash_utility.get_hash_key);
3243: --
3244: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3245: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3246: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 3448: ,ben_hash_utility.get_hash_key);

3444: +nvl(p_start_date-hr_api.g_sot,4)
3445: +nvl(p_end_date-hr_api.g_sot,5)
3446: +nvl(p_payroll_id,6)
3447: +nvl(p_element_type_id,7)
3448: ,ben_hash_utility.get_hash_key);
3449: --
3450: while g_annual_to_period_cache.exists(l_hv)
3451: loop
3452: --

Line 3600: ,ben_hash_utility.get_hash_key);

3596: +nvl(p_start_date-hr_api.g_sot,4)
3597: +nvl(p_end_date-hr_api.g_sot,5)
3598: +nvl(p_payroll_id,6)
3599: +nvl(p_element_type_id,7)
3600: ,ben_hash_utility.get_hash_key);
3601: --
3602: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3603: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3604: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 3807: ,ben_hash_utility.get_hash_key);

3803: +nvl(p_start_date-hr_api.g_sot,4)
3804: +nvl(p_end_date-hr_api.g_sot,5)
3805: +nvl(p_payroll_id,6)
3806: +nvl(p_element_type_id,7)
3807: ,ben_hash_utility.get_hash_key);
3808: --
3809: while g_annual_to_period_cache.exists(l_hv)
3810: loop
3811: --

Line 3927: ,ben_hash_utility.get_hash_key);

3923: +nvl(p_start_date-hr_api.g_sot,4)
3924: +nvl(p_end_date-hr_api.g_sot,5)
3925: +nvl(p_payroll_id,6)
3926: +nvl(p_element_type_id,7)
3927: ,ben_hash_utility.get_hash_key);
3928: --
3929: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3930: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3931: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 4084: ,ben_hash_utility.get_hash_key);

4080: +nvl(p_start_date-hr_api.g_sot,4)
4081: +nvl(p_end_date-hr_api.g_sot,5)
4082: +nvl(p_payroll_id,6)
4083: +nvl(p_element_type_id,7)
4084: ,ben_hash_utility.get_hash_key);
4085: --
4086: while g_annual_to_period_cache.exists(l_hv)
4087: loop
4088: --