APPS.PER_SALADMIN_ANALYTICS_PKG dependencies on HR_GENERAL

Line 40: CURSOR SALANALYTICS IS SELECT /*+ LEADING(SAL.DAY) */ SAL.EFFECTIVE_START_DATE EFFECTIVE_START_DATE ,CASE WHEN SAL.EFFECTIVE_START_DATE = TRUNC(SYSDATE) THEN HR_GENERAL.END_OF_TIME ELSE SAL.EFFECTIVE_END_DATE END EFFECTIVE_END_DATE

36: TYPE Sal_Analytics_Bulk_Collect IS TABLE OF PER_SALADMIN_ANALYTICS%ROWTYPE;
37: l_check_var NUMBER;
38: table_name_var VARCHAR2(300);
39: PSA Sal_Analytics_Bulk_Collect;
40: CURSOR SALANALYTICS IS SELECT /*+ LEADING(SAL.DAY) */ SAL.EFFECTIVE_START_DATE EFFECTIVE_START_DATE ,CASE WHEN SAL.EFFECTIVE_START_DATE = TRUNC(SYSDATE) THEN HR_GENERAL.END_OF_TIME ELSE SAL.EFFECTIVE_END_DATE END EFFECTIVE_END_DATE
41: ,SAL.JOB_ID JOB_ID
42: ,SAL.COUNTRY COUNTRY
43: ,SAL.PAY_BASIS_ID PAY_BASIS_ID
44: ,SUM(SAL.HEADCOUNT) TOTAL_HEADCOUNT