APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_FEEDS_F

Line 204: -- from hr_s_balance_feeds_f ... we only

200: -- Reimplemented code to avoid needless
201: -- deletion and recreation of balance
202: -- feeds (thereby avoiding needless loss
203: -- of latest balances). We don't now delete
204: -- from hr_s_balance_feeds_f ... we only
205: -- select back those feeds that don't match
206: -- rows in pay_balance_feeds_f instead.
207: -- Bug 1490386.
208: -- 115.40 amills 21-Dec-2000 1550308. Handle exception whereby

Line 1568: from hr_s_balance_feeds_f hrs

1564: -- Cursor to install child balance feeds
1565: -- that don't already exist in pay_balance_feeds_f
1566:
1567: select distinct *
1568: from hr_s_balance_feeds_f hrs
1569: where hrs.balance_type_id = bal_type_id
1570: and not exists (
1571: select null
1572: from pay_balance_feeds_f pbf

Line 1634: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F

1630:
1631: update /*+NO_INDEX*/ hr_s_BALANCE_CLASSIFICATIONS
1632: set balance_type_id = balance_type_id - 50000000;
1633:
1634: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
1635: set balance_type_id = balance_type_id - 50000000;
1636:
1637: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1638: set balance_type_id = balance_type_id - 50000000;

Line 1814: update hr_s_balance_feeds_f

1810: update hr_s_balance_classifications
1811: set balance_type_id = l_new_surrogate_key
1812: where balance_type_id = stu_rec.c_surrogate_key;
1813:
1814: update hr_s_balance_feeds_f
1815: set balance_type_id = l_new_surrogate_key,
1816: new_balance_type_flag = v_new_balance_type_flag
1817: where balance_type_id = stu_rec.c_surrogate_key;
1818:

Line 1884: delete from hr_s_balance_feeds_f

1880: delete from hr_s_defined_balances
1881: where balance_type_id = stu_Rec.c_surrogate_key;
1882:
1883:
1884: delete from hr_s_balance_feeds_f
1885: where balance_type_id = stu_Rec.c_surrogate_key;
1886:
1887: delete from hr_s_balance_types
1888: where rowid = stu_rec.rowid;

Line 2414: -- hr_s_balance_feeds_f.

2410: --
2411: -- This statement removes any balance feeds from
2412: -- pay_balance_feeds_f that belong to a balance_type_id
2413: -- in hr_s_balance_types but do not exist in
2414: -- hr_s_balance_feeds_f.
2415:
2416: delete from pay_balance_feeds_f pbf
2417: where pbf.balance_type_id = stu_rec.c_surrogate_key
2418: and pbf.business_group_id is null

Line 2423: from hr_s_balance_feeds_f hrs

2419: and pbf.legislation_code is not null
2420: and pbf.balance_feed_id <= l_initbfid
2421: and not exists (
2422: select null
2423: from hr_s_balance_feeds_f hrs
2424: where pbf.balance_type_id = hrs.balance_type_id
2425: and pbf.input_value_id = hrs.input_value_id
2426: and pbf.effective_start_date = hrs.effective_start_date
2427: and pbf.effective_end_date = hrs.effective_end_date);