[Home] [Help]
1531: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
1532: END LOOP;
1533: */
1534:
1535: INSERT INTO PAY_US_RPT_TOTALS
1536: (SESSION_ID
1537: ,ATTRIBUTE1
1538: ,ATTRIBUTE2
1539: ,VALUE1
1617: 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;
1618:
1619: */
1620:
1621: INSERT INTO PAY_US_RPT_TOTALS
1622: (SESSION_ID
1623: ,ATTRIBUTE1
1624: ,ATTRIBUTE2
1625: ,VALUE1
1674: FUNCTION AFTERREPORT RETURN BOOLEAN IS
1675: BEGIN
1676: -- HR_STANDARD.EVENT('AFTER REPORT');
1677: EXECUTE IMMEDIATE
1678: 'DELETE FROM pay_us_rpt_totals
1679: WHERE attribute1 = ''IPED5''';
1680: RETURN (TRUE);
1681: END AFTERREPORT;
1682: