DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 3398: hr_soft_coding_keyflex sft

3394: AND paei.aei_information1 = l_state /* Added for performance improvement Bug# 4344959 */
3395: AND paei.assignment_id = paf.assignment_id
3396: AND NOT EXISTS (SELECT null
3397: FROM hr_organization_information orgi,
3398: hr_soft_coding_keyflex sft
3399: WHERE orgi.organization_id = to_number(sft.segment1)
3400: AND sft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
3401: AND orgi.org_information1 = paei.aei_information1
3402: AND (orgi.org_information2 = paei.aei_information2