144: and asg.effective_end_date
145: AND asg.business_group_id = ppa_gen.business_group_id
146: AND ( asg.soft_coding_keyflex_id IN
147: (SELECT hsck.soft_coding_keyflex_id
148: FROM hr_soft_coding_keyflex hsck
149: WHERE hsck.segment1 = TO_CHAR(l_tax_unit_id)
150: OR hsck.segment11 = TO_CHAR(l_tax_unit_id) /* Bug 13955510 */
151: OR hsck.segment12 = TO_CHAR(l_tax_unit_id)
152: )
205: and asg.effective_end_date
206: AND asg.business_group_id = ppa_gen.business_group_id
207: AND ( asg.soft_coding_keyflex_id IN
208: (SELECT hsck.soft_coding_keyflex_id
209: FROM hr_soft_coding_keyflex hsck
210: WHERE hsck.segment1 = TO_CHAR(l_tax_unit_id)
211: OR hsck.segment11 = TO_CHAR(l_tax_unit_id) /* Bug 13955510 */
212: OR hsck.segment12 = TO_CHAR(l_tax_unit_id)
213: )