DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 1103: INSERT INTO PAY_US_RPT_TOTALS

1099: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
1100: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
1101: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
1102: END LOOP;
1103: INSERT INTO PAY_US_RPT_TOTALS
1104: (SESSION_ID
1105: ,ATTRIBUTE1
1106: ,ATTRIBUTE2
1107: ,VALUE1

Line 1173: INSERT INTO PAY_US_RPT_TOTALS

1169: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
1170: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
1171: 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;
1172: 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;
1173: INSERT INTO PAY_US_RPT_TOTALS
1174: (SESSION_ID
1175: ,ATTRIBUTE1
1176: ,ATTRIBUTE2
1177: ,VALUE1

Line 1222: 'DELETE FROM pay_us_rpt_totals

1218: FUNCTION AFTERREPORT RETURN BOOLEAN IS
1219: BEGIN
1220: -- HR_STANDARD.EVENT('AFTER REPORT');
1221: EXECUTE IMMEDIATE
1222: 'DELETE FROM pay_us_rpt_totals
1223: WHERE attribute1 = ''IPED5''';
1224: RETURN (TRUE);
1225: END AFTERREPORT;
1226: