DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_BALANCE_PKG

Line 1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1087: hr_utility.set_location(' Inside balance Loop ', 850);
1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1090:
1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1092: l_valid_asg_act_rec.assignment_action_id,
1093: g_employer_id,
1094: null,
1095: null,

Line 1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1105:
1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1107: l_valid_asg_act_rec.assignment_action_id,
1108: g_employer_id,
1109: null,
1110: null,

Line 1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1120:
1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1122: l_valid_asg_act_rec.assignment_action_id,
1123: g_employer_id,
1124: null,
1125: null,

Line 1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1135:
1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1137: l_valid_asg_act_rec.assignment_action_id,
1138: g_employer_id,
1139: null,
1140: null,

Line 1183: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1179: Raise l_ehecs_exception;
1180: END IF;
1181: */
1182: ELSE
1183: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1184: l_valid_asg_act_rec.assignment_action_id,
1185: g_employer_id,
1186: null,
1187: null,

Line 1202: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1199:
1200: l_mat_bal_val := nvl(l_mat_bal_val,0)
1201: +
1202: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1203: l_valid_asg_act_rec.assignment_action_id,
1204: g_employer_id,
1205: null,
1206: null,

Line 1223: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1219:
1220: l_sic_bal_val :=
1221: nvl(l_sic_bal_val,0)
1222: +
1223: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1224: l_valid_asg_act_rec.assignment_action_id,
1225: g_employer_id,
1226: null,
1227: null,

Line 1243: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1239:
1240: l_otl_bal_val :=
1241: l_otl_bal_val
1242: +
1243: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1244: l_valid_asg_act_rec.assignment_action_id,
1245: g_employer_id,
1246: null,
1247: null,

Line 1266: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1262:
1263: l_mat_bal_val :=
1264: nvl(l_mat_bal_val,0)
1265: +
1266: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1267: l_valid_asg_act_rec.assignment_action_id,
1268: g_employer_id,
1269: null,
1270: null,

Line 1287: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1283:
1284: l_sic_bal_val :=
1285: nvl(l_sic_bal_val,0)
1286: +
1287: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1288: l_valid_asg_act_rec.assignment_action_id,
1289: g_employer_id,
1290: null,
1291: null,

Line 1306: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1302:
1303: l_otl_bal_val :=
1304: nvl(l_otl_bal_val,0)
1305: +
1306: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1307: l_valid_asg_act_rec.assignment_action_id,
1308: g_employer_id,
1309: null,
1310: null,

Line 1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1321: hr_utility.set_location(' Inside balance Loop ', 850);
1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1324:
1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1326: l_valid_asg_act_rec.assignment_action_id,
1327: g_employer_id,
1328: null,
1329: null,

Line 1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1339:
1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1341: l_valid_asg_act_rec.assignment_action_id,
1342: g_employer_id,
1343: null,
1344: null,

Line 1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1354:
1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1356: l_valid_asg_act_rec.assignment_action_id,
1357: g_employer_id,
1358: null,
1359: null,

Line 1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1369:
1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1371: l_valid_asg_act_rec.assignment_action_id,
1372: g_employer_id,
1373: null,
1374: null,

Line 1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1384:
1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1386: l_valid_asg_act_rec.assignment_action_id,
1387: g_employer_id,
1388: null,
1389: null,

Line 1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1399:
1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1401: l_valid_asg_act_rec.assignment_action_id,
1402: g_employer_id,
1403: null,
1404: null,

Line 1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1414:
1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1416: l_valid_asg_act_rec.assignment_action_id,
1417: g_employer_id,
1418: null,
1419: null,

Line 1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1429:
1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1431: l_valid_asg_act_rec.assignment_action_id,
1432: g_employer_id,
1433: null,
1434: null,

Line 1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1444:
1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1446: l_valid_asg_act_rec.assignment_action_id,
1447: g_employer_id,
1448: null,
1449: null,

Line 1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1459:
1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1461: l_valid_asg_act_rec.assignment_action_id,
1462: g_employer_id,
1463: null,
1464: null,

Line 1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1476:
1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1478: l_valid_asg_act_rec.assignment_action_id,
1479: g_employer_id,
1480: null,
1481: null,

Line 1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1491:
1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1493: l_valid_asg_act_rec.assignment_action_id,
1494: g_employer_id,
1495: null,
1496: null,

Line 1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1506:
1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1508: l_valid_asg_act_rec.assignment_action_id,
1509: g_employer_id,
1510: null,
1511: null,

Line 1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1521:
1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1523: l_valid_asg_act_rec.assignment_action_id,
1524: g_employer_id,
1525: null,
1526: null,

Line 1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1536:
1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1538: l_valid_asg_act_rec.assignment_action_id,
1539: g_employer_id,
1540: null,
1541: null,

Line 1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1551:
1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1553: l_valid_asg_act_rec.assignment_action_id,
1554: g_employer_id,
1555: null,
1556: null,

Line 1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);
1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1569: l_valid_asg_act_rec.assignment_action_id,
1570: g_employer_id,
1571: null,
1572: null,

Line 1584: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1581: l_al_bal_val :=
1582: nvl(l_al_bal_val,0)
1583: +
1584: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1585: l_valid_asg_act_rec.assignment_action_id,
1586: g_employer_id,
1587: null,
1588: null,