979: peev.screen_entry_value|| '.00',
980: peev.screen_entry_value
981: )
982: from pay_element_entries_f pee,
983: pay_element_entry_values_f peev,
984: pay_input_values_f piv
985: WHERE l_effective_date
986: between pee.effective_start_date AND pee.effective_end_date
987: AND pee.element_entry_id = peev.element_entry_id
1169: select nvl(sum(pev.screen_entry_value),0)
1170: from pay_element_types_f pet,
1171: pay_input_values_f piv,
1172: pay_element_entries_f pee,
1173: pay_element_entry_Values_f pev,
1174: pay_payroll_actions ppa,
1175: pay_assignment_actions paa,
1176: pay_payroll_actions ppa2
1177: where pee.assignment_id = l_assignment_id