APPS.PQH_PQIPED9_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 1567: INSERT INTO PAY_US_RPT_TOTALS

1563: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
1564: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
1565: 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;
1566: 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;
1567: INSERT INTO PAY_US_RPT_TOTALS
1568: (SESSION_ID
1569: ,ATTRIBUTE1
1570: ,VALUE1
1571: ,VALUE2

Line 1631: INSERT INTO PAY_US_RPT_TOTALS

1627: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
1628: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
1629: 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;
1630: 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;
1631: INSERT INTO PAY_US_RPT_TOTALS
1632: (SESSION_ID
1633: ,ATTRIBUTE1
1634: ,VALUE1
1635: ,VALUE2

Line 1695: INSERT INTO PAY_US_RPT_TOTALS

1691: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
1692: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
1693: 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;
1694: 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;
1695: INSERT INTO PAY_US_RPT_TOTALS
1696: (SESSION_ID
1697: ,ATTRIBUTE1
1698: ,VALUE1
1699: ,VALUE2

Line 1769: INSERT INTO PAY_US_RPT_TOTALS

1765: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
1766: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
1767: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
1768: END LOOP;
1769: INSERT INTO PAY_US_RPT_TOTALS
1770: (SESSION_ID
1771: ,ATTRIBUTE1
1772: ,VALUE1
1773: ,VALUE2

Line 1818: 'DELETE FROM pay_us_rpt_totals

1814: temp number(15);
1815: BEGIN
1816: --HR_STANDARD.EVENT('AFTER REPORT');
1817: EXECUTE IMMEDIATE
1818: 'DELETE FROM pay_us_rpt_totals
1819: WHERE attribute1 = ''IPED9''';
1820: RETURN (TRUE);
1821: END AFTERREPORT;
1822: