DBA Data[Home] [Help]

APPS.PAYLINKINPUTVALUESF_46U_DYT dependencies on PAY_CORE_UTILS

Line 29: l_business_group_id := pay_core_utils.get_dyt_business_group(

25: IF NOT (hr_general.g_data_migrator_mode <> 'Y') THEN
26: RETURN;
27: END IF;
28: /* Initialising local variables */
29: l_business_group_id := pay_core_utils.get_dyt_business_group(
30: p_statement => 'select pel.business_group_id from pay_element_links_f pel where pel.element_link_id = '||:new.element_link_id||' and to_date('''||to_char(:new.effective_start_date, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') between pel.effective_start_date and pel.effective_end_date'
31: );
32: --
33: l_legislation_code := pay_core_utils.get_legislation_code(

Line 33: l_legislation_code := pay_core_utils.get_legislation_code(

29: l_business_group_id := pay_core_utils.get_dyt_business_group(
30: p_statement => 'select pel.business_group_id from pay_element_links_f pel where pel.element_link_id = '||:new.element_link_id||' and to_date('''||to_char(:new.effective_start_date, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') between pel.effective_start_date and pel.effective_end_date'
31: );
32: --
33: l_legislation_code := pay_core_utils.get_legislation_code(
34: p_bg_id => l_business_group_id
35: );
36: --
37: /* Is the trigger in an enabled functional area */