251: from pay_element_types_f pet,
252: pay_element_links_f pel,
253: pay_element_entries_f pee,
254: pay_element_entry_values_f peev,
255: pay_input_values_f piv
256: where pet.element_name = c_car_element_name
257: and pet.legislation_code = 'JP'
258: and p_effective_date
259: between pet.effective_start_date and pet.effective_end_date
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee,
338: pay_element_entry_values_f peev,
339: pay_input_values_f piv
340: where pet.element_name = c_train_element_name
341: and pet.legislation_code = 'JP'
342: and p_effective_date
343: between pet.effective_start_date and pet.effective_end_date