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_US_GARN_GEN dependencies on PAY_BALANCE_TYPES

Line 523: from pay_balance_types bt,

519:
520: cursor get_invol_bals is
521: select bt.balance_type_id,
522: bc.scale
523: from pay_balance_types bt,
524: pay_balance_classifications bc,
525: pay_element_classifications ec
526: where bt.balance_type_id = bc.balance_type_id
527: and bc.classification_id = ec.classification_id

Line 1084: FROM pay_balance_types

1080: begin
1081:
1082: SELECT balance_type_id
1083: INTO g_voldedns_balance_id
1084: FROM pay_balance_types
1085: WHERE balance_name = 'Voluntary Deductions'
1086: AND business_group_id IS NULL
1087: AND legislation_code = 'US';
1088:

Line 1106: FROM pay_balance_types

1102: begin
1103:
1104: SELECT balance_type_id
1105: INTO g_total_dedns_balance_id
1106: FROM pay_balance_types
1107: WHERE balance_name = 'Garn Total Dedns'
1108: AND business_group_id IS NULL
1109: AND legislation_code = 'US';
1110:

Line 1125: FROM pay_balance_types

1121: begin
1122:
1123: SELECT balance_type_id
1124: INTO g_total_fees_balance_id
1125: FROM pay_balance_types
1126: WHERE balance_name = 'Garn Total Fees'
1127: AND business_group_id IS NULL
1128: AND legislation_code = 'US';
1129:

Line 1144: FROM pay_balance_types

1140: begin
1141:
1142: SELECT balance_type_id
1143: INTO g_other_not_taken_bal_id
1144: FROM pay_balance_types
1145: WHERE balance_name = 'Other Garn Not Taken Amount'
1146: AND business_group_id IS NULL
1147: AND legislation_code = 'US';
1148:

Line 1170: FROM pay_balance_types

1166: begin
1167:
1168: SELECT balance_type_id
1169: INTO g_tax_levies_balance_id
1170: FROM pay_balance_types
1171: WHERE balance_name = 'Tax Levies'
1172: AND business_group_id IS NULL
1173: AND legislation_code = 'US';
1174:

Line 1196: FROM pay_balance_types

1192: begin
1193:
1194: SELECT balance_type_id
1195: INTO g_childsupp_count_balance_id
1196: FROM pay_balance_types
1197: WHERE balance_name = 'Child Supp Count'
1198: AND business_group_id IS NULL
1199: AND legislation_code = 'US';
1200:

Line 1215: FROM pay_balance_types

1211: begin
1212:
1213: SELECT balance_type_id
1214: INTO g_total_dedns_balance_id
1215: FROM pay_balance_types
1216: WHERE balance_name = 'Child Supp Total Dedns'
1217: AND business_group_id IS NULL
1218: AND legislation_code = 'US';
1219:

Line 1234: FROM pay_balance_types

1230: begin
1231:
1232: SELECT balance_type_id
1233: INTO g_total_amount_balance_id
1234: FROM pay_balance_types
1235: WHERE balance_name = 'Child Supp Total Amount'
1236: AND business_group_id IS NULL
1237: AND legislation_code = 'US';
1238:

Line 1253: FROM pay_balance_types

1249: begin
1250:
1251: SELECT balance_type_id
1252: INTO g_supp_not_taken_bal_id
1253: FROM pay_balance_types
1254: WHERE balance_name = 'Support Not Taken Amount'
1255: AND business_group_id IS NULL
1256: AND legislation_code = 'US';
1257:

Line 1273: FROM pay_balance_types

1269: begin
1270:
1271: SELECT balance_type_id
1272: INTO g_total_fees_balance_id
1273: FROM pay_balance_types
1274: WHERE balance_name = 'Child Supp Total Fees'
1275: AND business_group_id IS NULL
1276: AND legislation_code = 'US';
1277:

Line 1293: FROM pay_balance_types

1289: begin
1290:
1291: SELECT balance_type_id
1292: INTO g_wh_support_balance_id
1293: FROM pay_balance_types
1294: WHERE balance_name = 'Total Withheld Support'
1295: AND business_group_id IS NULL
1296: AND legislation_code = 'US';
1297:

Line 1312: FROM pay_balance_types

1308: begin
1309:
1310: SELECT balance_type_id
1311: INTO g_wh_fee_balance_id
1312: FROM pay_balance_types
1313: WHERE balance_name = 'Total Withheld Fee'
1314: AND business_group_id IS NULL
1315: AND legislation_code = 'US';
1316:

Line 1332: FROM pay_balance_types

1328: begin
1329:
1330: SELECT balance_type_id
1331: INTO g_net_balance_id
1332: FROM pay_balance_types
1333: WHERE balance_name = 'Net'
1334: AND business_group_id IS NULL
1335: AND legislation_code = 'US';
1336:

Line 1339: FROM pay_balance_types

1335: AND legislation_code = 'US';
1336:
1337: SELECT balance_type_id
1338: INTO g_payments_balance_id
1339: FROM pay_balance_types
1340: WHERE balance_name = 'Payments'
1341: AND business_group_id IS NULL
1342: AND legislation_code = 'US';
1343:

Line 2335: pay_balance_types_pkg.chk_balance_type(

2331: if already_exists = 0 then
2332:
2333: -- Check element name, ie. primary balance name, is unique to
2334: -- balances within this BG.
2335: pay_balance_types_pkg.chk_balance_type(
2336: p_row_id => NULL,
2337: p_business_group_id => p_bg_id,
2338: p_legislation_code => NULL,
2339: p_balance_name => garn_assoc_bal_names(i),

Line 2345: pay_balance_types_pkg.chk_balance_type(

2341: p_assignment_remuneration_flag => 'N');
2342:
2343: -- Check element name, ie. primary balance name, is unique to
2344: -- balances provided as startup data.
2345: pay_balance_types_pkg.chk_balance_type(
2346: p_row_id => NULL,
2347: p_business_group_id => NULL,
2348: p_legislation_code => 'US',
2349: p_balance_name => garn_assoc_bal_names(i),

Line 5075: FROM pay_balance_types

5071: -- as the Further Element Information descriptive flexfield are not set for
5072: -- the mentioned balances. Refer to Bug 2527761 for more information.
5073: CURSOR c_get_bal_type(l_bal_name varchar2) IS
5074: SELECT balance_type_id
5075: FROM pay_balance_types
5076: WHERE balance_name = p_ele_name || l_bal_name
5077: AND business_group_id + 0 = p_business_group_id;
5078:
5079: BEGIN

Line 5365: DELETE FROM pay_balance_types

5361: p_legislation_code => g_template_leg_code,
5362: p_mode => v_del_mode);
5363:
5364: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);
5365: DELETE FROM pay_balance_types
5366: WHERE balance_type_id = assoc_bals(i);
5367:
5368: END IF;
5369: