DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_HASH_UTILITY

Line 204: g_hash_key number := ben_hash_utility.get_hash_key;

200: --
201: --
202: g_package varchar2(80) := 'ben_distribute_rates';
203: --
204: g_hash_key number := ben_hash_utility.get_hash_key;
205: g_hash_jump number := ben_hash_utility.get_hash_jump;
206: --
207: -- Function cache stuff
208: --

Line 205: g_hash_jump number := ben_hash_utility.get_hash_jump;

201: --
202: g_package varchar2(80) := 'ben_distribute_rates';
203: --
204: g_hash_key number := ben_hash_utility.get_hash_key;
205: g_hash_jump number := ben_hash_utility.get_hash_jump;
206: --
207: -- Function cache stuff
208: --
209: type g_period_to_annual_row is record

Line 2773: ,ben_hash_utility.get_hash_key);

2769: +nvl(p_start_date-hr_api.g_sot,4)
2770: +nvl(p_end_date-hr_api.g_sot,5)
2771: +nvl(p_payroll_id,6)
2772: +nvl(p_element_type_id,7)
2773: ,ben_hash_utility.get_hash_key);
2774: --
2775: if nvl(g_period_to_annual_cache(l_hv).amount,-1) = nvl(p_amount,-1)
2776: and nvl(g_period_to_annual_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
2777: and nvl(g_period_to_annual_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 2969: ,ben_hash_utility.get_hash_key);

2965: +nvl(p_start_date-hr_api.g_sot,4)
2966: +nvl(p_end_date-hr_api.g_sot,5)
2967: +nvl(p_payroll_id,6)
2968: +nvl(p_element_type_id,7)
2969: ,ben_hash_utility.get_hash_key);
2970: --
2971: while g_period_to_annual_cache.exists(l_hv)
2972: loop
2973: --

Line 3100: ,ben_hash_utility.get_hash_key);

3096: +nvl(p_start_date-hr_api.g_sot,4)
3097: +nvl(p_end_date-hr_api.g_sot,5)
3098: +nvl(p_payroll_id,6)
3099: +nvl(p_element_type_id,7)
3100: ,ben_hash_utility.get_hash_key);
3101: --
3102: if nvl(g_period_to_annual_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3103: and nvl(g_period_to_annual_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3104: and nvl(g_period_to_annual_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 3302: ,ben_hash_utility.get_hash_key);

3298: +nvl(p_start_date-hr_api.g_sot,4)
3299: +nvl(p_end_date-hr_api.g_sot,5)
3300: +nvl(p_payroll_id,6)
3301: +nvl(p_element_type_id,7)
3302: ,ben_hash_utility.get_hash_key);
3303: --
3304: while g_period_to_annual_cache.exists(l_hv)
3305: loop
3306: --

Line 3478: ,ben_hash_utility.get_hash_key);

3474: +nvl(p_start_date-hr_api.g_sot,4)
3475: +nvl(p_end_date-hr_api.g_sot,5)
3476: +nvl(p_payroll_id,6)
3477: +nvl(p_element_type_id,7)
3478: ,ben_hash_utility.get_hash_key);
3479: --
3480: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3481: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3482: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 3713: ,ben_hash_utility.get_hash_key);

3709: +nvl(p_start_date-hr_api.g_sot,4)
3710: +nvl(p_end_date-hr_api.g_sot,5)
3711: +nvl(p_payroll_id,6)
3712: +nvl(p_element_type_id,7)
3713: ,ben_hash_utility.get_hash_key);
3714: --
3715: while g_annual_to_period_cache.exists(l_hv)
3716: loop
3717: --

Line 3888: ,ben_hash_utility.get_hash_key);

3884: +nvl(p_start_date-hr_api.g_sot,4)
3885: +nvl(p_end_date-hr_api.g_sot,5)
3886: +nvl(p_payroll_id,6)
3887: +nvl(p_element_type_id,7)
3888: ,ben_hash_utility.get_hash_key);
3889: --
3890: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
3891: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
3892: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 4126: ,ben_hash_utility.get_hash_key);

4122: +nvl(p_start_date-hr_api.g_sot,4)
4123: +nvl(p_end_date-hr_api.g_sot,5)
4124: +nvl(p_payroll_id,6)
4125: +nvl(p_element_type_id,7)
4126: ,ben_hash_utility.get_hash_key);
4127: --
4128: while g_annual_to_period_cache.exists(l_hv)
4129: loop
4130: --

Line 4246: ,ben_hash_utility.get_hash_key);

4242: +nvl(p_start_date-hr_api.g_sot,4)
4243: +nvl(p_end_date-hr_api.g_sot,5)
4244: +nvl(p_payroll_id,6)
4245: +nvl(p_element_type_id,7)
4246: ,ben_hash_utility.get_hash_key);
4247: --
4248: if nvl(g_annual_to_period_cache(l_hv).amount,-1) = nvl(p_amount,-1)
4249: and nvl(g_annual_to_period_cache(l_hv).enrt_rt_id,-1) = nvl(p_enrt_rt_id,-1)
4250: and nvl(g_annual_to_period_cache(l_hv).elig_per_elctbl_chc_id,-1) = nvl(p_elig_per_elctbl_chc_id,-1)

Line 4404: ,ben_hash_utility.get_hash_key);

4400: +nvl(p_start_date-hr_api.g_sot,4)
4401: +nvl(p_end_date-hr_api.g_sot,5)
4402: +nvl(p_payroll_id,6)
4403: +nvl(p_element_type_id,7)
4404: ,ben_hash_utility.get_hash_key);
4405: --
4406: while g_annual_to_period_cache.exists(l_hv)
4407: loop
4408: --