APPS.PERPERSONTYPEUSAGESF_1152U_DYT dependencies on FND_DATE

Line 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'

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(
34: p_bg_id => l_business_group_id