DBA Data[Home] [Help]

APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 2432: SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE

2428: AND (LINK.EMPLOYMENT_CATEGORY = ASGT.EMPLOYMENT_CATEGORY OR
2429: LINK.EMPLOYMENT_CATEGORY IS NULL)
2430: AND (LINK.PEOPLE_GROUP_ID IS NULL
2431: OR EXISTS (
2432: SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
2433: WHERE USAGE.ASSIGNMENT_ID = ASGT.ASSIGNMENT_ID
2434: AND USAGE.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
2435: AND (USAGE.EFFECTIVE_START_DATE <= p_end_date
2436: AND USAGE.EFFECTIVE_END_DATE >= p_start_date)))