DBA Data[Home] [Help]

APPS.PERPERSONTYPEUSAGESF_1152U_DYT dependencies on PAY_CORE_UTILS

Line 29: l_business_group_id := pay_core_utils.get_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_business_group(
30: p_statement => 'select business_group_id from per_all_people_f where person_id = '||:new.person_id||' and fnd_date.charDT_to_date('''||fnd_date.date_to_charDT(:new.effective_start_date) || ''') between effective_start_date and 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_business_group(
30: p_statement => 'select business_group_id from per_all_people_f where person_id = '||:new.person_id||' and fnd_date.charDT_to_date('''||fnd_date.date_to_charDT(:new.effective_start_date) || ''') between effective_start_date and 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 */