DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PAY_US_RPT_TOTALS

Line 15: 05-sep-2005 rsethupa 115.1 Delete records from PAY_US_RPT_TOTALS

11: -----------
12: Date Name Vers Bug Description
13: ----------- ---------- ----- -------- ----------------------------------
14: 10-AUG-2005 rsethupa 115.0 Created
15: 05-sep-2005 rsethupa 115.1 Delete records from PAY_US_RPT_TOTALS
16: in DEINIT code
17: 13-Sep-2005 sdhole 115.3 4577187 Changed the report type from YEMA to
18: YREND_YEMA.
19: 16-Sep-2005 sdhole 115.4 4613898 Modified ARCHIVE_INIT,ARCHIVE_DEINIT,

Line 510: into pay_us_rpt_totals(

506: l_step := 5;
507: if lv_result_value = 1 then
508: --
509: insert
510: into pay_us_rpt_totals(
511: session_id,
512: tax_unit_id,
513: value1,
514: attribute1,

Line 564: DELETE FROM pay_us_rpt_totals

560: g_session_id);
561: --
562: pay_archive.remove_report_actions(p_payroll_action_id);
563: --
564: DELETE FROM pay_us_rpt_totals
565: WHERE attribute1='YEAR END MISSING ASSIGNMENTS'
566: AND location_id = p_payroll_action_id;
567: --
568: hr_utility.trace('leaving archive_deinit');