[Home] [Help]
639: ,v_input_value_id IN NUMBER
640: ,v_effective_date IN DATE)
641: IS
642: select eev.screen_entry_value
643: from pay_element_entries_f ee,
644: pay_element_entry_values_f eev
645: where ee.assignment_id = v_assignment_id
646: and ee.element_type_id = v_element_type_id
647: and v_effective_date between ee.effective_start_date and ee.effective_end_date
2065: begin
2066:
2067: dt_api.find_dt_del_modes -- _and_dates
2068: (p_effective_date => p_effective_date,
2069: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',
2070: p_base_key_column => 'ELEMENT_ENTRY_ID',
2071: p_base_key_value => p_base_key_value,
2072: p_zap => l_zap_mode,
2073: p_delete => l_delete_mode,
2128: --
2129: cursor c_min_max_dt(p_element_entry_id number) is
2130: select min(effective_start_date),
2131: max(effective_end_date)
2132: from pay_element_entries_f
2133: where element_entry_id = p_element_entry_id;
2134: --
2135: l_min_start_date date;
2136: l_max_end_date date;
2142: pet.element_name,
2143: pet.processing_type
2144: from pay_element_types_f pet,
2145: pay_element_links_f pel,
2146: pay_element_entries_f pee,
2147: pay_element_entry_values_f pev
2148: where pev.element_entry_value_id = p_element_entry_value_id
2149: and pee.element_entry_id = pev.element_entry_id
2150: and pev.effective_start_date between pee.effective_start_date
2171: pee.element_link_id,
2172: pev.screen_entry_value
2173: from per_all_assignments_f asg,
2174: pay_element_links_f pel,
2175: pay_element_entries_f pee,
2176: pay_element_entry_values_f pev
2177: where asg.person_id = p_person_id
2178: and pee.assignment_id = asg.assignment_id
2179: and p_effective_date between asg.effective_start_date
2197: -- added for 8392328
2198: cursor c_get_ovn (p_element_entry_id in number
2199: ,p_effective_date in date) is
2200: select object_version_number
2201: from pay_element_entries_f pee
2202: where pee.element_entry_id = p_element_entry_id
2203: and p_effective_date = pee.effective_end_date;
2204: --
2205: begin