DBA Data[Home] [Help]

APPS.PQP_EXPPREPROC_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 148: FROM hr_soft_coding_keyflex hsck

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: )

Line 209: FROM hr_soft_coding_keyflex hsck

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: )