[Home] [Help]
614: select fnd_date.canonical_to_date (peev.screen_entry_value)
615: from pay_element_types_f pet,
616: pay_input_values_f piv,
617: pay_element_entries_f peef,
618: pay_element_entry_values_f peev
619: where pet.element_name = c_element_name
620: and pet.element_type_id = piv.element_type_id
621: and piv.name = c_input_val_name
622: and pet.legislation_code = 'NO'
653: c_eff_end_date date
654: ) is
655: select effective_start_date,
656: fnd_number.canonical_to_number (screen_entry_value) entry_value
657: from pay_element_entry_values_f peev
658: where element_entry_id = c_element_entry_id
659: and effective_start_date between c_eff_start_date and c_eff_end_date
660: and screen_entry_value is not null
661: and effective_start_date =
659: and effective_start_date between c_eff_start_date and c_eff_end_date
660: and screen_entry_value is not null
661: and effective_start_date =
662: (select max (effective_start_date)
663: from pay_element_entry_values_f peevf
664: where element_entry_id = c_element_entry_id
665: and effective_start_date between c_eff_start_date
666: and c_eff_end_date
667: -- and peevf.effective_start_date = peev.effective_start_date
673: c_element_entry_id number,
674: c_effective_date date
675: ) is
676: select fnd_number.canonical_to_number (screen_entry_value) entry_value
677: from pay_element_entry_values_f
678: where element_entry_id = c_element_entry_id
679: and c_effective_date between effective_start_date
680: and effective_end_date
681: and screen_entry_value is not null;
937: fetch csr_get_table_id into l_table1;
938: close csr_get_table_id;
939: --
940: --
941: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');
942: fetch csr_get_table_id into l_table2;
943: close csr_get_table_id;
944: --
945: --