APPS.HR_LEGISLATION dependencies on HR_S_MONETARY_UNITS

Line 5142: from hr_s_monetary_units;

5138: , last_update_login
5139: , created_by
5140: , creation_date
5141: , rowid
5142: from hr_s_monetary_units;
5143:
5144: stu_rec stu%ROWTYPE; -- Record definition for above SELECT
5145:
5146: PROCEDURE crt_exc (exception_type IN varchar2)

Line 5201: from hr_s_monetary_units;

5197:
5198:
5199: select count(*)
5200: into cnt
5201: from hr_s_monetary_units;
5202:
5203: If cnt=0 then return; end if;
5204:
5205:

Line 5211: from hr_s_monetary_units b

5207: into l_null_return
5208: from pay_monetary_units a
5209: where exists
5210: (select null
5211: from hr_s_monetary_units b
5212: where a.monetary_unit_id = b.monetary_unit_id
5213: );
5214:
5215: --conflict may exist

Line 5218: update hr_s_monetary_units

5214:
5215: --conflict may exist
5216: --update all monetary_unit_id's to remove conflict
5217:
5218: update hr_s_monetary_units
5219: set monetary_unit_id = monetary_unit_id - 50000000;
5220:
5221: update hr_s_application_ownerships
5222: set key_value = key_value - 50000000

Line 5234: from hr_s_monetary_units;

5230: select min(monetary_unit_id) - (count(*) *3)
5231: , max(monetary_unit_id) + (count(*) *3)
5232: into v_min_delivered
5233: , v_max_delivered
5234: from hr_s_monetary_units;
5235:
5236: select max(monetary_unit_id)
5237: into v_max_live
5238: from pay_monetary_units;

Line 5293: update hr_s_monetary_units

5289:
5290: -- Update all child entities
5291:
5292:
5293: update hr_s_monetary_units
5294: set monetary_unit_id = l_new_surrogate_key
5295: where monetary_unit_id = stu_rec.c_surrogate_key;
5296:
5297: update hr_s_application_ownerships

Line 5311: delete from hr_s_monetary_units

5307: -- Remove a row from either the startup tables or the installed tables
5308:
5309: BEGIN
5310:
5311: delete from hr_s_monetary_units
5312: where rowid = stu_rec.rowid;
5313:
5314: END remove;
5315: