DBA Data[Home] [Help]

APPS.PAYLINKINPUTVALUESF_46U_DYT dependencies on PAY_CORE_UTILS

Line 30: l_business_group_id := pay_core_utils.get_dyt_business_group(

26: IF NOT (hr_general.g_data_migrator_mode <> 'Y') THEN
27: RETURN;
28: END IF;
29: /* Initialising local variables */
30: l_business_group_id := pay_core_utils.get_dyt_business_group(
31: 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'
32: );
33: --
34: l_legislation_code := pay_core_utils.get_legislation_code(

Line 34: l_legislation_code := pay_core_utils.get_legislation_code(

30: l_business_group_id := pay_core_utils.get_dyt_business_group(
31: 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'
32: );
33: --
34: l_legislation_code := pay_core_utils.get_legislation_code(
35: p_bg_id => l_business_group_id
36: );
37: --
38: /* Is the trigger in an enabled functional area */