APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_CATEGORIES_F

Line 1094: from hr_s_balance_categories_f

1090: select max(effective_end_date) c_end
1091: , BALANCE_CATEGORY_ID c_surrogate_key
1092: , CATEGORY_NAME c_true_key
1093: , legislation_code
1094: from hr_s_balance_categories_f
1095: group by BALANCE_CATEGORY_ID
1096: , CATEGORY_NAME
1097: , legislation_code;
1098:

Line 1106: from hr_s_balance_categories_f

1102: -- This cursor accepts the primary key as a parameter and selects all
1103: -- date effective rows for it.
1104:
1105: select *
1106: from hr_s_balance_categories_f
1107: where BALANCE_CATEGORY_ID = pc_bal_cat_id;
1108:
1109: r_distinct c_distinct%ROWTYPE;
1110: r_each_row c_each_row%ROWTYPE;

Line 1128: from hr_s_balance_categories_f;

1124: BEGIN
1125:
1126: select count(*)
1127: into cnt
1128: from hr_s_balance_categories_f;
1129:
1130: If cnt=0 then return; end if;
1131:
1132: select distinct null

Line 1137: from hr_s_balance_categories_f b

1133: into l_null_return
1134: from pay_balance_categories_f a
1135: where exists
1136: (select null
1137: from hr_s_balance_categories_f b
1138: where a.BALANCE_CATEGORY_ID = b.BALANCE_CATEGORY_ID
1139: );
1140:
1141: --conflict may exist

Line 1144: update /*+NO_INDEX*/ hr_s_balance_categories_f

1140:
1141: --conflict may exist
1142: --update all user_row_id's to remove conflict
1143:
1144: update /*+NO_INDEX*/ hr_s_balance_categories_f
1145: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1146:
1147: update /*+NO_INDEX*/ hr_s_balance_types
1148: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;

Line 1158: from hr_s_balance_categories_f;

1154: select min(BALANCE_CATEGORY_ID) - (count(*) *3)
1155: , max(BALANCE_CATEGORY_ID) + (count(*) *3)
1156: into v_min_delivered
1157: , v_max_delivered
1158: from hr_s_balance_categories_f;
1159:
1160: select max(BALANCE_CATEGORY_ID)
1161: into v_max_live
1162: from pay_balance_categories_f;

Line 1214: delete from hr_s_balance_categories_f

1210: -- application ownership rows
1211:
1212: BEGIN
1213:
1214: delete from hr_s_balance_categories_f
1215: where BALANCE_CATEGORY_ID = v_id;
1216:
1217: END remove;
1218:

Line 1247: update hr_s_balance_categories_f

1243: r_distinct.c_true_key);
1244: --
1245: END;
1246:
1247: update hr_s_balance_categories_f
1248: set balance_category_id = l_new_balance_category_id
1249: where balance_category_id = r_distinct.c_surrogate_key;
1250:
1251: update hr_s_balance_types