DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 377: ,per_all_assignments_f pasg

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
381: and pee.effective_start_date between c_start_date and c_end_date

Line 498: ,per_all_assignments_f pasg

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
502: and pee.effective_start_date between c_start_date and c_end_date