DBA Data[Home] [Help]

APPS.PAY_PYAURECP_XMLP_PKG dependencies on STANDARD

Line 126: CP_TOTAL_STANDARD := 0;

122: CP_DIMENSION := '_LE_YTD';
123: END IF;
124: END IF;
125:
126: CP_TOTAL_STANDARD := 0;
127: CP_TOTAL_CURRENT_EMPLOYEES := 0;
128: CP_TOTAL_TERMINATED_EMPLOYEES := 0;
129: CP_TOTAL_GROSS := 0;
130: CP_TOTAL_ALLOWANCES := 0;

Line 150: CP_FW_TOTAL_STANDARD := 0;

146: CP_TOTAL_ASSESSABLE_INCOME := 0;
147: CP_TOTAL_WORKPLACE := 0;
148: CP_TOTAL_RESC := 0;
149: CP_TOTAL_FOREIGN_INCOME := 0;
150: CP_FW_TOTAL_STANDARD := 0;
151: CP_FW_TOTAL_GROSS := 0;
152: CP_FW_TOTAL_TID := 0;
153: CP_FW_TOTAL_FTID := 0;
154: CP_FW_TOTAL_LUMPSUMA := 0;

Line 165: CP_MAN_TOTAL_STANDARD := 0;

161: CP_TOTAL_NET_BAL := 0;
162: CP_FW_TOTAL_SUB_BAL := 0;
163: CP_FW_TOTAL_NET_BAL := 0;
164: CP_FW_TOTAL_ALLOWANCE := 0;
165: CP_MAN_TOTAL_STANDARD := 0;
166: CP_MAN_TOTAL_CURR_EMPLOYEES := 0;
167: CP_MAN_TOTAL_TERM_EMPLOYEES := 0;
168: CP_MAN_TOTAL_GROSS := 0;
169: CP_MAN_TOTAL_ALLOWANCES := 0;

Line 350: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;

346: CLOSE GET_EFFECTIVE_DATE;
347:
348: IF EMP_TYPE = 'T' THEN
349: IF ((LP_LST_YR_TERM = 'Y' AND TERM_DATE > CP_FBT_YR_START) OR (LP_LST_YR_TERM = 'N' AND TERM_DATE > CP_LST_YR_START)) AND TERM_DATE < CP_FIN_YR_START AND DATE_EARNED < CP_FIN_YR_START THEN
350: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
351: CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
352: L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START
353: ,ASSIGNMENT_ID
354: ,TAX_UNIT_ID

Line 364: CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;

360: ,CP_FINANCIAL_YEAR
361: ,CP_FIN_YR_END
362: ,TAX_UNIT_ID);
363: IF MANUAL_PS_ISSUED = 'Y' THEN
364: CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;
365: CP_MAN_TOTAL_TERM_EMPLOYEES := CP_MAN_TOTAL_TERM_EMPLOYEES + 1;
366: CP_MAN_TOTAL_RFB := CP_MAN_TOTAL_RFB + L_FBT_VALUE;
367: END IF;
368: RETURN (1);

Line 391: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;

387: END IF;
388:
389: END IF;
390: IF L_DISPLAY_FLAG = 'YES' THEN
391: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
392: PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START
393: ,P_YEAR_END => CP_FIN_YR_END
394: ,P_ASSIGNMENT_ID => ASSIGNMENT_ID
395: ,P_FBT_RATE => CP_FBT_GLOBAL

Line 440: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;

436: ,L_DISPLAY_FLAG
437: ,L_OUTPUT_TAB);
438:
439: IF L_DISPLAY_FLAG = 'YES' THEN
440: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
441:
442: IF EMP_TYPE = 'C' THEN
443: CP_TOTAL_CURRENT_EMPLOYEES := CP_TOTAL_CURRENT_EMPLOYEES + 1;
444: END IF;

Line 498: CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;

494: ,L_OUTPUT_TAB);
495:
496: END IF;
497: IF L_DISPLAY_FLAG = 'YES' THEN
498: CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;
499: IF EMP_TYPE = 'C' THEN
500: CP_MAN_TOTAL_CURR_EMPLOYEES := CP_MAN_TOTAL_CURR_EMPLOYEES + 1;
501: END IF;
502: IF EMP_TYPE = 'T' THEN

Line 572: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;

568: IF (L_OUTPUT_TAB(33).BALANCE_VALUE - L_OUTPUT_TAB(31).BALANCE_VALUE) <> 0
569: THEN
570: IF (L_OUTPUT_TAB(31).BALANCE_VALUE <> 0)
571: THEN
572: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;
573: END IF;
574: ELSIF (L_OUTPUT_TAB(31).BALANCE_VALUE <> 0)
575: THEN
576: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;

Line 576: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;

572: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;
573: END IF;
574: ELSIF (L_OUTPUT_TAB(31).BALANCE_VALUE <> 0)
575: THEN
576: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;
577: CP_FW_TOTAL_RFB := CP_FW_TOTAL_RFB + L_OUTPUT_TAB(2).BALANCE_VALUE;
578: CP_FW_TOTAL_RESC := CP_FW_TOTAL_RESC + L_OUTPUT_TAB(19).BALANCE_VALUE;
579: CP_FW_TOTAL_LUMPSUMD := CP_FW_TOTAL_LUMPSUMD + L_OUTPUT_TAB(6).BALANCE_VALUE;
580: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - 1;

Line 580: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - 1;

576: CP_FW_TOTAL_STANDARD := CP_FW_TOTAL_STANDARD + 1;
577: CP_FW_TOTAL_RFB := CP_FW_TOTAL_RFB + L_OUTPUT_TAB(2).BALANCE_VALUE;
578: CP_FW_TOTAL_RESC := CP_FW_TOTAL_RESC + L_OUTPUT_TAB(19).BALANCE_VALUE;
579: CP_FW_TOTAL_LUMPSUMD := CP_FW_TOTAL_LUMPSUMD + L_OUTPUT_TAB(6).BALANCE_VALUE;
580: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - 1;
581: END IF;
582:
583: END IF;
584:

Line 647: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - CP_MAN_TOTAL_STANDARD;

643: CP_TOTAL_GROSS := (L_GROUP_OUTPUT_TAB(6).BALANCE_VALUE + L_GROUP_OUTPUT_TAB(7).BALANCE_VALUE) + CP_TOTAL_WORKPLACE -
644: (GREATEST(CP_TOTAL_ALLOWANCES,0) + CP_TOTAL_CDEP + CP_TOTAL_LUMPSUM_E_PAY+ CP_TOTAL_FOREIGN_INCOME);
645: END IF;
646: IF (CP_ASSGT_COUNTER = CP_ASSGT_TOTAL) THEN
647: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - CP_MAN_TOTAL_STANDARD;
648: CP_TOTAL_CURRENT_EMPLOYEES := CP_TOTAL_CURRENT_EMPLOYEES - CP_MAN_TOTAL_CURR_EMPLOYEES;
649: CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES - CP_MAN_TOTAL_TERM_EMPLOYEES;
650: CP_TOTAL_GROSS := CP_TOTAL_GROSS - CP_MAN_TOTAL_GROSS - CP_FW_TOTAL_GROSS ;
651: CP_TOTAL_ALLOWANCES := CP_TOTAL_ALLOWANCES - CP_MAN_TOTAL_ALLOWANCES- CP_FW_TOTAL_ALLOWANCE;

Line 709: FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER IS

705: BEGIN
706: RETURN CP_FBT_YR_END;
707: END CP_FBT_YR_END_P;
708:
709: FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER IS
710: BEGIN
711: RETURN CP_TOTAL_STANDARD;
712: END CP_TOTAL_STANDARD_P;
713:

Line 711: RETURN CP_TOTAL_STANDARD;

707: END CP_FBT_YR_END_P;
708:
709: FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER IS
710: BEGIN
711: RETURN CP_TOTAL_STANDARD;
712: END CP_TOTAL_STANDARD_P;
713:
714: FUNCTION CP_TOTAL_ETP_P RETURN NUMBER IS
715: BEGIN

Line 712: END CP_TOTAL_STANDARD_P;

708:
709: FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER IS
710: BEGIN
711: RETURN CP_TOTAL_STANDARD;
712: END CP_TOTAL_STANDARD_P;
713:
714: FUNCTION CP_TOTAL_ETP_P RETURN NUMBER IS
715: BEGIN
716: RETURN CP_TOTAL_ETP;

Line 925: FUNCTION CP_FW_TOTAL_STANDARD_P RETURN NUMBER IS

921: BEGIN
922: RETURN CP_FW_TOTAL_RFB;
923: END CP_FW_TOTAL_RFB_P;
924:
925: FUNCTION CP_FW_TOTAL_STANDARD_P RETURN NUMBER IS
926: BEGIN
927: RETURN CP_FW_TOTAL_STANDARD;
928: END CP_FW_TOTAL_STANDARD_P;
929:

Line 927: RETURN CP_FW_TOTAL_STANDARD;

923: END CP_FW_TOTAL_RFB_P;
924:
925: FUNCTION CP_FW_TOTAL_STANDARD_P RETURN NUMBER IS
926: BEGIN
927: RETURN CP_FW_TOTAL_STANDARD;
928: END CP_FW_TOTAL_STANDARD_P;
929:
930: FUNCTION CP_FW_TOTAL_SUB_BAL_P RETURN NUMBER IS
931: BEGIN

Line 928: END CP_FW_TOTAL_STANDARD_P;

924:
925: FUNCTION CP_FW_TOTAL_STANDARD_P RETURN NUMBER IS
926: BEGIN
927: RETURN CP_FW_TOTAL_STANDARD;
928: END CP_FW_TOTAL_STANDARD_P;
929:
930: FUNCTION CP_FW_TOTAL_SUB_BAL_P RETURN NUMBER IS
931: BEGIN
932: RETURN CP_FW_TOTAL_SUB_BAL;

Line 950: FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER IS

946: BEGIN
947: RETURN CP_FW_TOTAL_WORKPLACE;
948: END CP_FW_TOTAL_WORKPLACE_P;
949:
950: FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER IS
951: BEGIN
952: RETURN CP_MAN_TOTAL_STANDARD;
953: END CP_MAN_TOTAL_STANDARD_P;
954:

Line 952: RETURN CP_MAN_TOTAL_STANDARD;

948: END CP_FW_TOTAL_WORKPLACE_P;
949:
950: FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER IS
951: BEGIN
952: RETURN CP_MAN_TOTAL_STANDARD;
953: END CP_MAN_TOTAL_STANDARD_P;
954:
955: FUNCTION CP_MAN_TOTAL_ETP_P RETURN NUMBER IS
956: BEGIN

Line 953: END CP_MAN_TOTAL_STANDARD_P;

949:
950: FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER IS
951: BEGIN
952: RETURN CP_MAN_TOTAL_STANDARD;
953: END CP_MAN_TOTAL_STANDARD_P;
954:
955: FUNCTION CP_MAN_TOTAL_ETP_P RETURN NUMBER IS
956: BEGIN
957: RETURN CP_MAN_TOTAL_ETP;