APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PAY_ELEMENT_ENTRIES_F

Line 262: FROM pay_element_entries_f

258: ,p_effective_end_date => l_effective_end_date);
259: hr_utility.set_location(' IN Create, setting subpriority for entry_id='||l_element_entry_id,30);
260:
261: SELECT max(object_version_number) INTO l_ovn
262: FROM pay_element_entries_f
263: WHERE element_entry_id = l_element_entry_id;
264:
265: SELECT to_number(substr(to_char(p_date_start,'J'),4,4)) INTO l_sub
266: FROM dual;

Line 322: FROM pay_element_entries_f

318: ,p_effective_end_date => l_effective_end_date);
319: hr_utility.set_location(' IN Update, setting subpriority for entry_id='||l_element_entry_id,30);
320:
321: SELECT max(object_version_number) INTO l_ovn
322: FROM pay_element_entries_f
323: WHERE element_entry_id = l_element_entry_id;
324:
325: select business_group_id INTO l_bus_grp_id
326: from per_absence_attendances

Line 376: ,pay_element_entries_f pee

372: ,c_start_date date
373: ,c_end_date date) is
374: select nvl(sum(pevm.screen_entry_value),0)
375: from pay_element_entry_values_f pevm
376: ,pay_element_entries_f pee
377: ,per_all_assignments_f pasg
378: where pevm.input_value_id = c_type_m_iv_id
379: and pee.element_entry_id = pevm.element_entry_id
380: and pevm.effective_start_date between c_start_date and c_end_date

Line 497: ,pay_element_entries_f pee

493: ,c_end_date date
494: ,c_person_id number) is
495: select nvl(sum(pevm.screen_entry_value),0)
496: from pay_element_entry_values_f pevm
497: ,pay_element_entries_f pee
498: ,per_all_assignments_f pasg
499: where pevm.input_value_id = c_type_m_iv_id
500: and pee.element_entry_id = pevm.element_entry_id
501: and pevm.effective_start_date between c_start_date and c_end_date