DBA Data[Home] [Help]

APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 2496: SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE

2492: AND (LINK.EMPLOYMENT_CATEGORY = ASGT.EMPLOYMENT_CATEGORY OR
2493: LINK.EMPLOYMENT_CATEGORY IS NULL)
2494: AND (LINK.PEOPLE_GROUP_ID IS NULL
2495: OR EXISTS (
2496: SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
2497: WHERE USAGE.ASSIGNMENT_ID = ASGT.ASSIGNMENT_ID
2498: AND USAGE.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
2499: AND (USAGE.EFFECTIVE_START_DATE <= p_end_date
2500: AND USAGE.EFFECTIVE_END_DATE >= p_start_date)))