DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 375: from pay_element_entry_values_f pevm

371: c_type_m_iv_id number
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

Line 496: from pay_element_entry_values_f pevm

492: ,c_start_date date
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