13: L_TT_SUP_CNT NUMBER;
14: L_TT_FINAL_YR_SUP_CNT NUMBER;
15: L_TE_CUR_YR_SUP_CNT NUMBER;
16: L_TD_CUR_YR_SUP_CNT NUMBER;
17: L_START_OF_TIME DATE := HR_GENERAL.START_OF_TIME;
18: BEGIN
19: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
20: ,'01'
21: ,L_START_OF_TIME