APPS.HR_LEGISLATION dependencies on HR_S_REPORT_FORMAT_ITEMS_F

Line 6408: from hr_s_report_format_items_f;

6404: last_update_login ,
6405: created_by ,
6406: creation_date ,
6407: rowid
6408: from hr_s_report_format_items_f;
6409:
6410:
6411: stu_rec stu%ROWTYPE;
6412:

Line 6432: from hr_s_report_format_items_f;

6428: --with the delivered values
6429:
6430: select count(*)
6431: into cnt
6432: from hr_s_report_format_items_f;
6433:
6434: If cnt=0 then return; end if;
6435:
6436: select distinct null

Line 6441: from hr_s_report_format_items_f b

6437: into l_null_return
6438: from pay_report_format_items_f a
6439: where exists
6440: (select null
6441: from hr_s_report_format_items_f b
6442: where a.report_format_item_id = b.report_format_item_id
6443: );
6444:
6445: update hr_s_report_format_items_f

Line 6445: update hr_s_report_format_items_f

6441: from hr_s_report_format_items_f b
6442: where a.report_format_item_id = b.report_format_item_id
6443: );
6444:
6445: update hr_s_report_format_items_f
6446: set report_format_item_id=report_format_item_id -50000000;
6447:
6448: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
6449:

Line 6457: from hr_s_report_format_items_f;

6453: select min(report_format_item_id) - (count(*) *3)
6454: , max(report_format_item_id) + (count(*) *3)
6455: into v_min_delivered
6456: , v_max_delivered
6457: from hr_s_report_format_items_f;
6458:
6459: select max(report_format_item_id)
6460: into v_max_live
6461: from pay_report_format_items_f;

Line 6533: update hr_s_report_format_items_f

6529: from dual;
6530:
6531: end if;
6532:
6533: update hr_s_report_format_items_f
6534: set report_format_item_id = l_new_surrogate_key
6535: where report_type = stu_rec.report_type
6536: and report_qualifier = stu_rec.report_qualifier
6537: and report_category = stu_rec.report_category

Line 6549: delete from hr_s_report_format_items_f

6545: -- Remove a row from either the startup tables or the installed tables
6546:
6547: BEGIN
6548:
6549: delete from hr_s_report_format_items_f
6550: where rowid = stu_rec.rowid;
6551:
6552:
6553: END remove;