eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on PAY_BALANCE_CATEGORIES_F

Line 302: -- pay_balance_categories_f

298: -- 115.94 DVickers 06-MAY-2003 del dim routes based on bal dim id
299: -- and priority not route_id
300: -- 115.95 DVickers 04-JUN-2003 new_category_name rollback correction
301: -- 115.95.11510.2 DVickers 17-JUL-2003 user_category_name col support for
302: -- pay_balance_categories_f
303: -- 115.95.11510.3 DVickers 18-JUL-2003 insert category_name if
304: -- user_category_name is null
305: -- 115.96 Scchakra 16-JUL-2003 Bug 2982582. Added code in install_att
306: -- to install startup data in table

Line 1134: from pay_balance_categories_f a

1130: If cnt=0 then return; end if;
1131:
1132: select distinct null
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

Line 1162: from pay_balance_categories_f;

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;
1163:
1164: select pay_balance_categories_s.nextval
1165: into v_sequence_number
1166: from dual;

Line 1199: insert_hr_stu_exceptions('pay_balance_categories_f'

1195: -- not be raised more than once.
1196:
1197: rollback to new_category_name;
1198:
1199: insert_hr_stu_exceptions('pay_balance_categories_f'
1200: , r_distinct.c_surrogate_key
1201: , exception_type
1202: , r_distinct.c_true_key);
1203:

Line 1229: from pay_balance_categories_f

1225: BEGIN
1226:
1227: select distinct BALANCE_CATEGORY_ID
1228: into l_new_balance_category_id
1229: from pay_balance_categories_f
1230: where category_name = r_distinct.c_true_key
1231: and business_Group_id is null
1232: and nvl(legislation_code, 'x') = nvl(r_distinct.legislation_code,'x');
1233:

Line 1277: from pay_balance_categories_f a

1273: BEGIN
1274:
1275: select distinct null
1276: into l_null_return
1277: from pay_balance_categories_f a
1278: where a.category_name = r_distinct.c_true_key
1279: and a.business_group_id is not null
1280: and exists (select null from per_business_groups b
1281: where b.business_group_id = a.business_group_id

Line 1303: from pay_balance_categories_f

1299: BEGIN
1300: --
1301: select distinct null
1302: into l_null_return
1303: from pay_balance_categories_f
1304: where category_name = r_distinct.c_true_key
1305: and nvl(legislation_code,'x') <>
1306: nvl(r_distinct.legislation_code,'x')
1307: and (legislation_code is null

Line 1350: delete from pay_balance_categories_f

1346: -- Get new surrogate id and update child references
1347: update_uid;
1348: ELSE
1349: -- Phase = 2
1350: delete from pay_balance_categories_f
1351: where balance_category_id = r_distinct.c_surrogate_key;
1352:
1353: FOR each_row IN c_each_row(r_distinct.c_surrogate_key) LOOP
1354: r_each_row := each_row;

Line 1359: insert into pay_balance_categories_f

1355:
1356: IF NOT check_parents THEN RAISE row_in_error; END IF;
1357:
1358: BEGIN
1359: insert into pay_balance_categories_f
1360: ( BALANCE_CATEGORY_ID
1361: ,CATEGORY_NAME
1362: ,EFFECTIVE_START_DATE
1363: ,EFFECTIVE_END_DATE

Line 2097: from pay_balance_categories_f

2093: IF stu_rec.balance_category_id IS NOT NULL THEN
2094: BEGIN
2095: select distinct null
2096: into l_null_return
2097: from pay_balance_categories_f
2098: where balance_category_id = stu_rec.balance_category_id;
2099:
2100: EXCEPTION WHEN NO_DATA_FOUND THEN
2101: crt_exc('Parent balance category does not exist');

Line 6627: -- PAY_BALANCE_CATEGORIES_F_TL

6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL
6626: -- PAY_MONETARY_UNITS_TL
6627: -- PAY_BALANCE_CATEGORIES_F_TL
6628:
6629:
6630: PROCEDURE install_pbtt
6631: ----------------------

Line 7447: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.

7443: --
7444: PROCEDURE install_pbct
7445: ----------------------
7446: IS
7447: -- Seeds the PAY_BALANCE_CATEGORIES_F_TL table.
7448:
7449: CURSOR c_balance_categories IS
7450: select
7451: bc.BALANCE_CATEGORY_ID,

Line 7460: from PAY_BALANCE_CATEGORIES_F bc,

7456: bc.LAST_UPDATED_BY,
7457: bc.LAST_UPDATE_LOGIN,
7458: bc.CREATED_BY,
7459: bc.CREATION_DATE
7460: from PAY_BALANCE_CATEGORIES_F bc,
7461: FND_LANGUAGES L,
7462: FND_LANGUAGES B
7463: where L.INSTALLED_FLAG in ('I', 'B')
7464: and B.INSTALLED_FLAG = 'B'

Line 7467: from PAY_BALANCE_CATEGORIES_F_TL bct

7463: where L.INSTALLED_FLAG in ('I', 'B')
7464: and B.INSTALLED_FLAG = 'B'
7465: and not exists (
7466: select '1'
7467: from PAY_BALANCE_CATEGORIES_F_TL bct
7468: where bct.BALANCE_CATEGORY_ID = bc.BALANCE_CATEGORY_ID
7469: and bct.language = l.language_code);
7470:
7471: l_counter NUMBER(3) := 0;

Line 7480: insert into PAY_BALANCE_CATEGORIES_F_TL

7476: FOR l_rec IN c_balance_categories LOOP
7477:
7478: -- Insert all selected rows into the TL table.
7479: -- If the row exist in the TL table then it will be ignored.
7480: insert into PAY_BALANCE_CATEGORIES_F_TL
7481: (
7482: BALANCE_CATEGORY_ID,
7483: LANGUAGE,
7484: SOURCE_LANG,

Line 7505: from PAY_BALANCE_CATEGORIES_F_TL bct

7501: l_rec.CREATION_DATE
7502: from dual
7503: where not exists (
7504: select '1'
7505: from PAY_BALANCE_CATEGORIES_F_TL bct
7506: where bct.BALANCE_CATEGORY_ID = l_rec.BALANCE_CATEGORY_ID
7507: and bct.language = l_rec.trans_lang);
7508:
7509: l_counter := l_counter + 1;