DBA Data[Home] [Help]

APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on STANDARD

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

2501: AND (ELEMENT.PROCESSING_TYPE = 'R' OR ASGT.PAYROLL_ID IS NOT NULL)
2502: AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL
2503: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2504: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2505: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2506: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2507: hr_general.end_of_time),
2508: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2509: ORDER BY Display_Value;