APPS.HR_LEGISLATION dependencies on HR_S_MONETARY_UNITS

Line 5392: from hr_s_monetary_units;

5388: , last_update_login
5389: , created_by
5390: , creation_date
5391: , rowid
5392: from hr_s_monetary_units;
5393:
5394: stu_rec stu%ROWTYPE; -- Record definition for above SELECT
5395:
5396: PROCEDURE crt_exc (exception_type IN varchar2)

Line 5451: from hr_s_monetary_units;

5447:
5448:
5449: select count(*)
5450: into cnt
5451: from hr_s_monetary_units;
5452:
5453: If cnt=0 then return; end if;
5454:
5455:

Line 5461: from hr_s_monetary_units b

5457: into l_null_return
5458: from pay_monetary_units a
5459: where exists
5460: (select null
5461: from hr_s_monetary_units b
5462: where a.monetary_unit_id = b.monetary_unit_id
5463: );
5464:
5465: --conflict may exist

Line 5468: update hr_s_monetary_units

5464:
5465: --conflict may exist
5466: --update all monetary_unit_id's to remove conflict
5467:
5468: update hr_s_monetary_units
5469: set monetary_unit_id = monetary_unit_id - 50000000;
5470:
5471: update hr_s_application_ownerships
5472: set key_value = key_value - 50000000

Line 5484: from hr_s_monetary_units;

5480: select min(monetary_unit_id) - (count(*) *3)
5481: , max(monetary_unit_id) + (count(*) *3)
5482: into v_min_delivered
5483: , v_max_delivered
5484: from hr_s_monetary_units;
5485:
5486: select max(monetary_unit_id)
5487: into v_max_live
5488: from pay_monetary_units;

Line 5543: update hr_s_monetary_units

5539:
5540: -- Update all child entities
5541:
5542:
5543: update hr_s_monetary_units
5544: set monetary_unit_id = l_new_surrogate_key
5545: where monetary_unit_id = stu_rec.c_surrogate_key;
5546:
5547: update hr_s_application_ownerships

Line 5561: delete from hr_s_monetary_units

5557: -- Remove a row from either the startup tables or the installed tables
5558:
5559: BEGIN
5560:
5561: delete from hr_s_monetary_units
5562: where rowid = stu_rec.rowid;
5563:
5564: END remove;
5565: