DBA Data[Home] [Help]

APPS.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on HR_GENERAL

Line 93: CASE WHEN sal.effective_start_date = TRUNC(sysdate) THEN hr_general.end_of_time

89: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Looping for Assignment ID '||EMP_ASSIGNMENT_ID,20);
90:
91: OPEN PAYCHANGE FOR SELECT
92: sal.effective_start_date effective_start_date,
93: CASE WHEN sal.effective_start_date = TRUNC(sysdate) THEN hr_general.end_of_time
94: ELSE sal.effective_end_date
95: END effective_end_date,
96: sal.job_id job_id,
97: sal.country country,