DBA Data[Home] [Help]

APPS.PQH_PQIPED10_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 933: INSERT INTO PAY_US_RPT_TOTALS

929: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
930: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
931: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
932: END LOOP;
933: INSERT INTO PAY_US_RPT_TOTALS
934: (SESSION_ID
935: ,ATTRIBUTE1
936: ,VALUE1
937: ,VALUE2

Line 1000: INSERT INTO PAY_US_RPT_TOTALS

996: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
997: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
998: 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;
999: 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;
1000: INSERT INTO PAY_US_RPT_TOTALS
1001: (SESSION_ID
1002: ,ATTRIBUTE1
1003: ,ATTRIBUTE2
1004: ,VALUE1

Line 1057: 'DELETE FROM pay_us_rpt_totals

1053: function AfterReport return boolean is
1054: begin
1055: --hr_standard.event('AFTER REPORT');
1056: EXECUTE IMMEDIATE
1057: 'DELETE FROM pay_us_rpt_totals
1058: WHERE attribute1 = ''IPED10''';
1059:
1060: return (TRUE);
1061: end;