APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_CATEGORIES_F

Line 1299: from hr_s_balance_categories_f

1295: select max(effective_end_date) c_end
1296: , BALANCE_CATEGORY_ID c_surrogate_key
1297: , CATEGORY_NAME c_true_key
1298: , legislation_code
1299: from hr_s_balance_categories_f
1300: group by BALANCE_CATEGORY_ID
1301: , CATEGORY_NAME
1302: , legislation_code;
1303:

Line 1311: from hr_s_balance_categories_f

1307: -- This cursor accepts the primary key as a parameter and selects all
1308: -- date effective rows for it.
1309:
1310: select *
1311: from hr_s_balance_categories_f
1312: where BALANCE_CATEGORY_ID = pc_bal_cat_id;
1313:
1314: r_distinct c_distinct%ROWTYPE;
1315: r_each_row c_each_row%ROWTYPE;

Line 1333: from hr_s_balance_categories_f;

1329: BEGIN
1330:
1331: select count(*)
1332: into cnt
1333: from hr_s_balance_categories_f;
1334:
1335: If cnt=0 then return; end if;
1336:
1337: select distinct null

Line 1342: from hr_s_balance_categories_f b

1338: into l_null_return
1339: from pay_balance_categories_f a
1340: where exists
1341: (select null
1342: from hr_s_balance_categories_f b
1343: where a.BALANCE_CATEGORY_ID = b.BALANCE_CATEGORY_ID
1344: );
1345:
1346: --conflict may exist

Line 1349: update /*+NO_INDEX*/ hr_s_balance_categories_f

1345:
1346: --conflict may exist
1347: --update all user_row_id's to remove conflict
1348:
1349: update /*+NO_INDEX*/ hr_s_balance_categories_f
1350: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1351:
1352: update /*+NO_INDEX*/ hr_s_balance_types
1353: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;

Line 1363: from hr_s_balance_categories_f;

1359: select min(BALANCE_CATEGORY_ID) - (count(*) *3)
1360: , max(BALANCE_CATEGORY_ID) + (count(*) *3)
1361: into v_min_delivered
1362: , v_max_delivered
1363: from hr_s_balance_categories_f;
1364:
1365: select max(BALANCE_CATEGORY_ID)
1366: into v_max_live
1367: from pay_balance_categories_f;

Line 1419: delete from hr_s_balance_categories_f

1415: -- application ownership rows
1416:
1417: BEGIN
1418:
1419: delete from hr_s_balance_categories_f
1420: where BALANCE_CATEGORY_ID = v_id;
1421:
1422: END remove;
1423:

Line 1452: update hr_s_balance_categories_f

1448: r_distinct.c_true_key);
1449: --
1450: END;
1451:
1452: update hr_s_balance_categories_f
1453: set balance_category_id = l_new_balance_category_id
1454: where balance_category_id = r_distinct.c_surrogate_key;
1455:
1456: update hr_s_balance_types