APPS.HR_LEGISLATION dependencies on HR_S_PAYMENT_TYPES

Line 4062: from hr_s_payment_types;

4058: , last_update_login
4059: , created_by
4060: , creation_date
4061: , rowid
4062: from hr_s_payment_types;
4063:
4064: stu_rec stu%ROWTYPE; -- Record for above SELECT
4065:
4066:

Line 4102: from hr_s_payment_types;

4098:
4099:
4100: select count(*)
4101: into cnt
4102: from hr_s_payment_types;
4103:
4104: If cnt=0 then return; end if;
4105:
4106:

Line 4112: from hr_s_payment_types b

4108: into l_null_return
4109: from pay_payment_types a
4110: where exists
4111: (select null
4112: from hr_s_payment_types b
4113: where a.payment_type_id = b.payment_type_id
4114: );
4115:
4116: --conflict may exist

Line 4119: update /*+NO_INDEX*/ hr_s_payment_types

4115:
4116: --conflict may exist
4117: --update all payment_type_id's to remove conflict
4118:
4119: update /*+NO_INDEX*/ hr_s_payment_types
4120: set payment_type_id = payment_type_id - 50000000;
4121:
4122: update hr_s_application_ownerships
4123: set key_value = key_value - 50000000

Line 4134: from hr_s_payment_types;

4130: select min(payment_type_id) - (count(*) *3)
4131: , max(payment_type_id) + (count(*) *3)
4132: into v_min_delivered
4133: , v_max_delivered
4134: from hr_s_payment_types;
4135:
4136: select max(payment_type_id)
4137: into v_max_live
4138: from pay_payment_types;

Line 4211: update hr_s_payment_types

4207:
4208: -- Update all child entities
4209:
4210:
4211: update hr_s_payment_types
4212: set payment_type_id = l_new_surrogate_key
4213: where payment_type_id = stu_rec.c_surrogate_key;
4214:
4215: update hr_s_application_ownerships

Line 4228: delete from hr_s_payment_types

4224: -- Remove a row from either the startup tables or the installed tables
4225:
4226: BEGIN
4227:
4228: delete from hr_s_payment_types
4229: where rowid = stu_rec.rowid;
4230:
4231:
4232: END remove;