980:
981: select peevf.screen_entry_value * l_period_frequency
982: into g_assignments_table(l_assignment.assignment_id).annual_income
983: from pay_element_entry_values_f peevf,
984: pay_element_entries_f peef
985: where peef.assignment_id = l_assignment.assignment_id
986: and p_report_date between peef.effective_start_date and peef.effective_end_date
987: and peevf.element_entry_id = peef.element_entry_id
988: and peevf.input_value_id = l_input_value_id
4944:
4945: select peevf.screen_entry_value * l_period_frequency
4946: into g_assignments_table(l_assignment.assignment_id).annual_income
4947: from pay_element_entry_values_f peevf,
4948: pay_element_entries_f peef
4949: where peef.assignment_id = l_assignment.assignment_id
4950: and p_report_date between peef.effective_start_date and peef.effective_end_date
4951: and peevf.element_entry_id = peef.element_entry_id
4952: and peevf.input_value_id = l_input_value_id