DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2461: hr_soft_coding_keyflex sft

2457: AND paei.aei_information1 = l_state /* Added for performance improvement Bug# 4344959 */
2458: AND paei.assignment_id = paf.assignment_id
2459: AND NOT EXISTS (SELECT null
2460: FROM hr_organization_information orgi,
2461: hr_soft_coding_keyflex sft
2462: WHERE orgi.organization_id = to_number(sft.segment1)
2463: AND sft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2464: AND orgi.org_information1 = paei.aei_information1
2465: AND (orgi.org_information2 = paei.aei_information2