6248: ,peef.entry_information1 -- Medical Indicator
6249: ,peef.entry_information3 -- DOC Number
6250: ,paa.assignment_action_id
6251: ,pet.element_type_id
6252: from pay_element_entry_values_f peev,
6253: pay_input_values_f piv_att,
6254: pay_element_entries_f peef,
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6331: ,peef.entry_information1 -- Medical Indicator
6332: ,peef.entry_information3 -- DOC Number
6333: ,paa.assignment_action_id
6334: ,peef.element_type_id
6335: from pay_element_entry_values_f peev,
6336: pay_element_entry_values_f peev_pay,
6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6332: ,peef.entry_information3 -- DOC Number
6333: ,paa.assignment_action_id
6334: ,peef.element_type_id
6335: from pay_element_entry_values_f peev,
6336: pay_element_entry_values_f peev_pay,
6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6440: cursor upgrade_status is
6441: select pet.element_type_id
6442: ,to_char(ppa.date_earned, 'DD-MM-YYYY')
6443: ,nvl(element_information4,-1)
6444: from pay_element_entry_values_f peev,
6445: pay_input_values_f piv_att,
6446: pay_element_entries_f peef,
6447: pay_run_results prr_att,
6448: pay_payroll_actions ppa,