DBA Data[Home] [Help]

APPS.PAYPERSONALPAYMENTMETH_49U_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 paf.business_group_id from per_assignments_f paf where assignment_id = '||:old.assignment_id||' and to_date('''||to_char(:old.effective_start_date, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') between paf.effective_start_date and paf.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 paf.business_group_id from per_assignments_f paf where assignment_id = '||:old.assignment_id||' and to_date('''||to_char(:old.effective_start_date, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') between paf.effective_start_date and paf.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 */