DBA Data[Home] [Help]

APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on STANDARD

Line 2441: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),

2437: AND (ELEMENT.PROCESSING_TYPE = 'R' OR ASGT.PAYROLL_ID IS NOT NULL)
2438: AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL
2439: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2440: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2441: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2442: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2443: hr_general.end_of_time),
2444: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2445: ORDER BY Display_Value;