APPS.PQH_PQIPED8_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 2616: INSERT INTO PAY_US_RPT_TOTALS

2612: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
2613: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
2614: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
2615: END LOOP;
2616: INSERT INTO PAY_US_RPT_TOTALS
2617: (SESSION_ID
2618: ,ATTRIBUTE1
2619: ,VALUE1
2620: ,VALUE2

Line 2683: INSERT INTO PAY_US_RPT_TOTALS

2679: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
2680: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
2681: L_TOT_MEN := L_TOT_MEN + L_TMR_BNH_MEN + L_TMR_AMAI_MEN + L_TMR_AP_MEN + L_TMR_H_MEN + L_TMR_WNH_MEN + L_TMR_UR_MEN;
2682: L_TOT_WMEN := L_TOT_WMEN + L_TMR_BNH_WMEN + L_TMR_AMAI_WMEN + L_TMR_AP_WMEN + L_TMR_H_WMEN + L_TMR_WNH_WMEN + L_TMR_UR_WMEN;
2683: INSERT INTO PAY_US_RPT_TOTALS
2684: (SESSION_ID
2685: ,ATTRIBUTE1
2686: ,VALUE1
2687: ,VALUE2

Line 2760: INSERT INTO PAY_US_RPT_TOTALS

2756: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
2757: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
2758: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
2759: END LOOP;
2760: INSERT INTO PAY_US_RPT_TOTALS
2761: (SESSION_ID
2762: ,ATTRIBUTE1
2763: ,VALUE1
2764: ,VALUE2

Line 2827: INSERT INTO PAY_US_RPT_TOTALS

2823: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
2824: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
2825: L_TOT_MEN := L_TOT_MEN + L_TMR_BNH_MEN + L_TMR_AMAI_MEN + L_TMR_AP_MEN + L_TMR_H_MEN + L_TMR_WNH_MEN + L_TMR_UR_MEN;
2826: L_TOT_WMEN := L_TOT_WMEN + L_TMR_BNH_WMEN + L_TMR_AMAI_WMEN + L_TMR_AP_WMEN + L_TMR_H_WMEN + L_TMR_WNH_WMEN + L_TMR_UR_WMEN;
2827: INSERT INTO PAY_US_RPT_TOTALS
2828: (SESSION_ID
2829: ,ATTRIBUTE1
2830: ,VALUE1
2831: ,VALUE2

Line 2904: INSERT INTO PAY_US_RPT_TOTALS

2900: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
2901: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
2902: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
2903: END LOOP;
2904: INSERT INTO PAY_US_RPT_TOTALS
2905: (SESSION_ID
2906: ,ATTRIBUTE1
2907: ,VALUE1
2908: ,VALUE2

Line 2971: INSERT INTO PAY_US_RPT_TOTALS

2967: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
2968: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
2969: L_TOT_MEN := L_TOT_MEN + L_TMR_BNH_MEN + L_TMR_AMAI_MEN + L_TMR_AP_MEN + L_TMR_H_MEN + L_TMR_WNH_MEN + L_TMR_UR_MEN;
2970: L_TOT_WMEN := L_TOT_WMEN + L_TMR_BNH_WMEN + L_TMR_AMAI_WMEN + L_TMR_AP_WMEN + L_TMR_H_WMEN + L_TMR_WNH_WMEN + L_TMR_UR_WMEN;
2971: INSERT INTO PAY_US_RPT_TOTALS
2972: (SESSION_ID
2973: ,ATTRIBUTE1
2974: ,VALUE1
2975: ,VALUE2

Line 3062: 'DELETE FROM pay_us_rpt_totals

3058: function AfterReport return boolean is
3059: begin
3060: --hr_standard.event('AFTER REPORT');
3061: EXECUTE IMMEDIATE
3062: 'DELETE FROM pay_us_rpt_totals
3063: WHERE attribute1 = ''IPED8''';
3064:
3065: return (TRUE);
3066: end;