APPS.PQH_PQIPED7_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 514: INTO PAY_US_RPT_TOTALS(SESSION_ID,

510: END LOOP;
511: */
512:
513: INSERT
514: INTO PAY_US_RPT_TOTALS(SESSION_ID,
515: ATTRIBUTE1, ATTRIBUTE2, VALUE1, VALUE2, VALUE3, VALUE4, VALUE5, VALUE6, VALUE7,
516: VALUE8, VALUE9, VALUE10, VALUE11, VALUE12, VALUE13, VALUE14, VALUE15, VALUE16, VALUE17,
517: VALUE18, VALUE19, VALUE20, VALUE21)
518: VALUES(USERENV('SESSIONID'), 'IPED7', SC, LINE, L_NR_MEN, L_NR_WMEN, L_BNH_MEN,

Line 584: INTO PAY_US_RPT_TOTALS(SESSION_ID, ATTRIBUTE1,

580: 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;
581: */
582:
583: INSERT
584: INTO PAY_US_RPT_TOTALS(SESSION_ID, ATTRIBUTE1,
585: ATTRIBUTE2, VALUE1, VALUE2, VALUE3, VALUE4, VALUE5,
586: VALUE6, VALUE7, VALUE8, VALUE9, VALUE10, VALUE11, VALUE12, VALUE13,
587: VALUE14, VALUE15, VALUE16, VALUE17, VALUE18, VALUE19, VALUE20, VALUE21)
588: VALUES(USERENV('SESSIONID'), 'IPED7', SC, LINE, L_NR_MEN, L_NR_WMEN, L_BNH_MEN,

Line 608: EXECUTE IMMEDIATE 'DELETE FROM PAY_US_RPT_TOTALS

604:
605: function AfterReport return boolean is
606: begin
607: --hr_standard.event('AFTER REPORT');
608: EXECUTE IMMEDIATE 'DELETE FROM PAY_US_RPT_TOTALS
609: WHERE ATTRIBUTE1 = ''IPED7''';
610: return (TRUE);
611: end;
612: