[Home] [Help]
1508: select ext.assignment_extra_info_id
1509: ,pen.per_in_ler_id
1510: from per_assignment_extra_info ext
1511: ,per_all_assignments_f asg
1512: ,ben_prtt_enrt_rslt_f pen
1513: where ext.information_type = 'CWBRANK'
1514: and ext.aei_information_category = 'CWBRANK'
1515: and ext.aei_information3 is not null
1516: and ext.aei_information5 is not null