APPS.PQH_PQHUSEPR_XMLP_PKG dependencies on PQH_TENURE_DETAIL

Line 19: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

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
22: ,SYSDATE);
23: CP_TENTRACK_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 23: CP_TENTRACK_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

19: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
20: ,'01'
21: ,L_START_OF_TIME
22: ,SYSDATE);
23: CP_TENTRACK_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
24: ,'02'
25: ,L_START_OF_TIME
26: ,SYSDATE);
27: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 27: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

23: CP_TENTRACK_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
24: ,'02'
25: ,L_START_OF_TIME
26: ,SYSDATE);
27: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
28: ,'04'
29: ,L_START_OF_TIME
30: ,SYSDATE);
31: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 31: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

27: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
28: ,'04'
29: ,L_START_OF_TIME
30: ,SYSDATE);
31: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
32: ,'05'
33: ,L_START_OF_TIME
34: ,SYSDATE);
35: RETURN 0;