APPS.HR_LEGISLATION dependencies on HR_S_REPORT_FORMAT_ITEMS_F

Line 6158: from hr_s_report_format_items_f;

6154: last_update_login ,
6155: created_by ,
6156: creation_date ,
6157: rowid
6158: from hr_s_report_format_items_f;
6159:
6160:
6161: stu_rec stu%ROWTYPE;
6162:

Line 6182: from hr_s_report_format_items_f;

6178: --with the delivered values
6179:
6180: select count(*)
6181: into cnt
6182: from hr_s_report_format_items_f;
6183:
6184: If cnt=0 then return; end if;
6185:
6186: select distinct null

Line 6191: from hr_s_report_format_items_f b

6187: into l_null_return
6188: from pay_report_format_items_f a
6189: where exists
6190: (select null
6191: from hr_s_report_format_items_f b
6192: where a.report_format_item_id = b.report_format_item_id
6193: );
6194:
6195: update hr_s_report_format_items_f

Line 6195: update hr_s_report_format_items_f

6191: from hr_s_report_format_items_f b
6192: where a.report_format_item_id = b.report_format_item_id
6193: );
6194:
6195: update hr_s_report_format_items_f
6196: set report_format_item_id=report_format_item_id -50000000;
6197:
6198: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
6199:

Line 6207: from hr_s_report_format_items_f;

6203: select min(report_format_item_id) - (count(*) *3)
6204: , max(report_format_item_id) + (count(*) *3)
6205: into v_min_delivered
6206: , v_max_delivered
6207: from hr_s_report_format_items_f;
6208:
6209: select max(report_format_item_id)
6210: into v_max_live
6211: from pay_report_format_items_f;

Line 6283: update hr_s_report_format_items_f

6279: from dual;
6280:
6281: end if;
6282:
6283: update hr_s_report_format_items_f
6284: set report_format_item_id = l_new_surrogate_key
6285: where report_type = stu_rec.report_type
6286: and report_qualifier = stu_rec.report_qualifier
6287: and report_category = stu_rec.report_category

Line 6299: delete from hr_s_report_format_items_f

6295: -- Remove a row from either the startup tables or the installed tables
6296:
6297: BEGIN
6298:
6299: delete from hr_s_report_format_items_f
6300: where rowid = stu_rec.rowid;
6301:
6302:
6303: END remove;