CMP_PRE_SALARY_ADDITIONAL_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
SALARY_ID DATE_FROM ASSIGNMENT_ID PREV_AMT_CUR_FREQ

Query

SQL_Statement
SELECT SALARY_ID, DATE_FROM, ASSIGNMENT_ID, cmp_ff_dbi_pkg.get_prev_sal_in_curr_freq(sal.SALARY_ID,sal.DATE_FROM) PREV_AMT_CUR_FREQ FROM CMP_SALARY sal