APPS.HR_LEGISLATION dependencies on HR_S_PAYMENT_TYPES

Line 4309: from hr_s_payment_types;

4305: , created_by
4306: , creation_date
4307: , rowid
4308: , reconciliation_function -- Added for bug 8726506
4309: from hr_s_payment_types;
4310:
4311: stu_rec stu%ROWTYPE; -- Record for above SELECT
4312:
4313:

Line 4349: from hr_s_payment_types;

4345:
4346:
4347: select count(*)
4348: into cnt
4349: from hr_s_payment_types;
4350:
4351: If cnt=0 then return; end if;
4352:
4353:

Line 4359: from hr_s_payment_types b

4355: into l_null_return
4356: from pay_payment_types a
4357: where exists
4358: (select null
4359: from hr_s_payment_types b
4360: where a.payment_type_id = b.payment_type_id
4361: );
4362:
4363: --conflict may exist

Line 4366: update /*+NO_INDEX*/ hr_s_payment_types

4362:
4363: --conflict may exist
4364: --update all payment_type_id's to remove conflict
4365:
4366: update /*+NO_INDEX*/ hr_s_payment_types
4367: set payment_type_id = payment_type_id - 50000000;
4368:
4369: update hr_s_application_ownerships
4370: set key_value = key_value - 50000000

Line 4381: from hr_s_payment_types;

4377: select min(payment_type_id) - (count(*) *3)
4378: , max(payment_type_id) + (count(*) *3)
4379: into v_min_delivered
4380: , v_max_delivered
4381: from hr_s_payment_types;
4382:
4383: select max(payment_type_id)
4384: into v_max_live
4385: from pay_payment_types;

Line 4458: update hr_s_payment_types

4454:
4455: -- Update all child entities
4456:
4457:
4458: update hr_s_payment_types
4459: set payment_type_id = l_new_surrogate_key
4460: where payment_type_id = stu_rec.c_surrogate_key;
4461:
4462: update hr_s_application_ownerships

Line 4475: delete from hr_s_payment_types

4471: -- Remove a row from either the startup tables or the installed tables
4472:
4473: BEGIN
4474:
4475: delete from hr_s_payment_types
4476: where rowid = stu_rec.rowid;
4477:
4478:
4479: END remove;