875: ,min(decode(piv2.name, 'Secondary CAC', nvl(peev2.screen_entry_value,'x'), null)) Secondary_CAC
876: FROM pay_element_entries_f peef1
877: ,pay_element_entry_values_f peev1
878: ,pay_element_entry_values_f peev2
879: ,pay_input_values_f piv1
880: ,pay_input_values_f piv2
881: ,pay_element_types_f pet
882: WHERE pet.element_name = c_element_name
883: AND piv1.element_type_id = pet.element_type_id
876: FROM pay_element_entries_f peef1
877: ,pay_element_entry_values_f peev1
878: ,pay_element_entry_values_f peev2
879: ,pay_input_values_f piv1
880: ,pay_input_values_f piv2
881: ,pay_element_types_f pet
882: WHERE pet.element_name = c_element_name
883: AND piv1.element_type_id = pet.element_type_id
884: AND piv2.element_type_id = pet.element_type_id
1177: FROM pay_element_entries_f pee
1178: ,pay_element_entries_f pee2
1179: ,pay_element_types_f pet
1180: ,pay_element_types_f pet2
1181: ,pay_input_values_f piv
1182: ,pay_input_values_f piv2
1183: ,pay_element_entry_values_f peev
1184: ,pay_element_entry_values_f peev2
1185: WHERE pee.assignment_id = c_assignment_id
1178: ,pay_element_entries_f pee2
1179: ,pay_element_types_f pet
1180: ,pay_element_types_f pet2
1181: ,pay_input_values_f piv
1182: ,pay_input_values_f piv2
1183: ,pay_element_entry_values_f peev
1184: ,pay_element_entry_values_f peev2
1185: WHERE pee.assignment_id = c_assignment_id
1186: AND pee2.assignment_id = pee.assignment_id