APPS.PQH_PQIPED6_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 290: INTO pay_us_rpt_totals(session_id, attribute1, attribute2, value1, value2, value3, value4,

286: l_tot_wmen := l_tot_wmen + j.bnhwmen + j.am_alwmen + j.a_pwmen + j.hwmen + j.wnhwmen + j.urwmen;
287: END LOOP;
288:
289: INSERT
290: INTO pay_us_rpt_totals(session_id, attribute1, attribute2, value1, value2, value3, value4,
291: value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18)
292: VALUES(userenv('sessionid'), 'IPED6', salary_range, line, sc,
293: l_nr_men, l_nr_wmen, l_bnh_men, l_bnh_wmen, l_amai_men, l_amai_wmen, l_ap_men, l_ap_wmen, l_h_men, l_h_wmen, l_wnh_men,
294: l_wnh_wmen, l_ur_men, l_ur_wmen, l_tot_men, l_tot_wmen);

Line 304: EXECUTE IMMEDIATE 'DELETE FROM pay_us_rpt_totals

300:
301: function AfterReport return boolean is
302: begin
303: --hr_standard.event('AFTER REPORT');
304: EXECUTE IMMEDIATE 'DELETE FROM pay_us_rpt_totals
305: WHERE attribute1 = ''IPED6''';
306: return (TRUE);
307: end;
308: