APPS.PQH_PQHUSRCP_XMLP_PKG dependencies on PQH_TENURE_DETAIL

Line 13: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

9:
10: FUNCTION CF_GETTENURECOUNTFORMULA RETURN NUMBER IS
11: L_START_OF_TIME DATE := HR_GENERAL.START_OF_TIME;
12: BEGIN
13: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
14: ,'01'
15: ,L_START_OF_TIME
16: ,P_END_DATE);
17: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 17: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

13: CP_TENURED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
14: ,'01'
15: ,L_START_OF_TIME
16: ,P_END_DATE);
17: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
18: ,'04'
19: ,L_START_OF_TIME
20: ,P_END_DATE);
21: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 21: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

17: CP_TENELIGIBLE_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
18: ,'04'
19: ,L_START_OF_TIME
20: ,P_END_DATE);
21: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
22: ,'05'
23: ,L_START_OF_TIME
24: ,P_END_DATE);
25: CP_TENUREDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 25: CP_TENUREDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

21: CP_TENDENIED_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
22: ,'05'
23: ,L_START_OF_TIME
24: ,P_END_DATE);
25: CP_TENUREDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
26: ,'01'
27: ,P_START_DATE
28: ,P_END_DATE);
29: CP_TENELIGIBLEPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 29: CP_TENELIGIBLEPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

25: CP_TENUREDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
26: ,'01'
27: ,P_START_DATE
28: ,P_END_DATE);
29: CP_TENELIGIBLEPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
30: ,'04'
31: ,P_START_DATE
32: ,P_END_DATE);
33: CP_TENDENIEDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

Line 33: CP_TENDENIEDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID

29: CP_TENELIGIBLEPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
30: ,'04'
31: ,P_START_DATE
32: ,P_END_DATE);
33: CP_TENDENIEDPERIOD_CNT := PQH_TENURE_DETAIL.GETPERIODSTATUSCOUNT(P_SUPERVISOR_ID
34: ,'05'
35: ,P_START_DATE
36: ,P_END_DATE);
37: RETURN 0;

Line 169: CP_TENUREDMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID

165: END CF_SET_TOTAL_FOR_PERIODFORMULA;
166:
167: FUNCTION CF_GETTENURECNTFORMULA(MANAGER_ID IN NUMBER) RETURN NUMBER IS
168: BEGIN
169: CP_TENUREDMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
170: ,'01'
171: ,P_END_DATE);
172: CP_TENELIGIBLEMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
173: ,'04'

Line 172: CP_TENELIGIBLEMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID

168: BEGIN
169: CP_TENUREDMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
170: ,'01'
171: ,P_END_DATE);
172: CP_TENELIGIBLEMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
173: ,'04'
174: ,P_END_DATE);
175: CP_TENUREDENIED_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
176: ,'05'

Line 175: CP_TENUREDENIED_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID

171: ,P_END_DATE);
172: CP_TENELIGIBLEMGR_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
173: ,'04'
174: ,P_END_DATE);
175: CP_TENUREDENIED_CNT := PQH_TENURE_DETAIL.GETSUPSTATUSCOUNT(MANAGER_ID
176: ,'05'
177: ,P_END_DATE);
178: RETURN 0;
179: END CF_GETTENURECNTFORMULA;