DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_BALANCE_PKG

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

1343: hr_utility.set_location(' Inside balance Loop ', 850);
1344: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1345: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1346:
1347: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1348: l_valid_asg_act_rec.assignment_action_id,
1349: g_employer_id,
1350: null,
1351: null,

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

1358: hr_utility.set_location(' Inside balance Loop ', 850);
1359: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1360: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1361:
1362: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1363: l_valid_asg_act_rec.assignment_action_id,
1364: g_employer_id,
1365: null,
1366: null,

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

1373: hr_utility.set_location(' Inside balance Loop ', 850);
1374: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1375: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1376:
1377: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1378: l_valid_asg_act_rec.assignment_action_id,
1379: g_employer_id,
1380: null,
1381: null,

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

1388: hr_utility.set_location(' Inside balance Loop ', 850);
1389: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1390: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1391:
1392: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1393: l_valid_asg_act_rec.assignment_action_id,
1394: g_employer_id,
1395: null,
1396: null,

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

1462: Raise l_ehecs_exception;
1463: END IF;
1464: */
1465: ELSE
1466: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1467: l_valid_asg_act_rec.assignment_action_id,
1468: g_employer_id,
1469: null,
1470: null,

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

1481: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1482:
1483: l_mat_bal_val := nvl(l_mat_bal_val,0)
1484: +
1485: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1486: l_valid_asg_act_rec.assignment_action_id,
1487: g_employer_id,
1488: null,
1489: null,

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

1502:
1503: l_sic_bal_val :=
1504: nvl(l_sic_bal_val,0)
1505: +
1506: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1507: l_valid_asg_act_rec.assignment_action_id,
1508: g_employer_id,
1509: null,
1510: null,

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

1522:
1523: l_otl_bal_val :=
1524: l_otl_bal_val
1525: +
1526: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1527: l_valid_asg_act_rec.assignment_action_id,
1528: g_employer_id,
1529: null,
1530: null,

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

1545:
1546: l_mat_bal_val :=
1547: nvl(l_mat_bal_val,0)
1548: +
1549: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1550: l_valid_asg_act_rec.assignment_action_id,
1551: g_employer_id,
1552: null,
1553: null,

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

1566:
1567: l_sic_bal_val :=
1568: nvl(l_sic_bal_val,0)
1569: +
1570: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1571: l_valid_asg_act_rec.assignment_action_id,
1572: g_employer_id,
1573: null,
1574: null,

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

1585:
1586: l_otl_bal_val :=
1587: nvl(l_otl_bal_val,0)
1588: +
1589: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1590: l_valid_asg_act_rec.assignment_action_id,
1591: g_employer_id,
1592: null,
1593: null,

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

1604: hr_utility.set_location(' Inside balance Loop ', 850);
1605: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1606: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1607:
1608: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1609: l_valid_asg_act_rec.assignment_action_id,
1610: g_employer_id,
1611: null,
1612: null,

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

1619: hr_utility.set_location(' Inside balance Loop ', 850);
1620: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1621: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1622:
1623: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1624: l_valid_asg_act_rec.assignment_action_id,
1625: g_employer_id,
1626: null,
1627: null,

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

1634: hr_utility.set_location(' Inside balance Loop ', 850);
1635: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1636: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1637:
1638: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1639: l_valid_asg_act_rec.assignment_action_id,
1640: g_employer_id,
1641: null,
1642: null,

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

1649: hr_utility.set_location(' Inside balance Loop ', 850);
1650: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1651: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1652:
1653: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1654: l_valid_asg_act_rec.assignment_action_id,
1655: g_employer_id,
1656: null,
1657: null,

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

1664: hr_utility.set_location(' Inside balance Loop ', 850);
1665: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1666: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1667:
1668: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1669: l_valid_asg_act_rec.assignment_action_id,
1670: g_employer_id,
1671: null,
1672: null,

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

1679: hr_utility.set_location(' Inside balance Loop ', 850);
1680: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1681: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1682:
1683: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1684: l_valid_asg_act_rec.assignment_action_id,
1685: g_employer_id,
1686: null,
1687: null,

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

1694: hr_utility.set_location(' Inside balance Loop ', 850);
1695: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1696: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1697:
1698: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1699: l_valid_asg_act_rec.assignment_action_id,
1700: g_employer_id,
1701: null,
1702: null,

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

1709: hr_utility.set_location(' Inside balance Loop ', 850);
1710: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1711: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1712:
1713: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1714: l_valid_asg_act_rec.assignment_action_id,
1715: g_employer_id,
1716: null,
1717: null,

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

1724: hr_utility.set_location(' Inside balance Loop ', 850);
1725: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1726: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1727:
1728: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1729: l_valid_asg_act_rec.assignment_action_id,
1730: g_employer_id,
1731: null,
1732: null,

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

1739: hr_utility.set_location(' Inside balance Loop ', 850);
1740: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1741: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1742:
1743: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1744: l_valid_asg_act_rec.assignment_action_id,
1745: g_employer_id,
1746: null,
1747: null,

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

1756: hr_utility.set_location(' Inside balance Loop ', 850);
1757: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1758: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1759:
1760: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1761: l_valid_asg_act_rec.assignment_action_id,
1762: g_employer_id,
1763: null,
1764: null,

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

1771: hr_utility.set_location(' Inside balance Loop ', 850);
1772: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1773: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1774:
1775: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1776: l_valid_asg_act_rec.assignment_action_id,
1777: g_employer_id,
1778: null,
1779: null,

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

1786: hr_utility.set_location(' Inside balance Loop ', 850);
1787: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1788: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1789:
1790: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1791: l_valid_asg_act_rec.assignment_action_id,
1792: g_employer_id,
1793: null,
1794: null,

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

1801: hr_utility.set_location(' Inside balance Loop ', 850);
1802: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1803: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1804:
1805: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1806: l_valid_asg_act_rec.assignment_action_id,
1807: g_employer_id,
1808: null,
1809: null,

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

1816: hr_utility.set_location(' Inside balance Loop ', 850);
1817: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1818: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1819:
1820: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1821: l_valid_asg_act_rec.assignment_action_id,
1822: g_employer_id,
1823: null,
1824: null,

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

1831: hr_utility.set_location(' Inside balance Loop ', 850);
1832: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1833: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1834:
1835: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1836: l_valid_asg_act_rec.assignment_action_id,
1837: g_employer_id,
1838: null,
1839: null,

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

1847: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1848: hr_utility.set_location(' Inside balance Loop ', 850);
1849: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1850: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1851: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1852: l_valid_asg_act_rec.assignment_action_id,
1853: g_employer_id,
1854: null,
1855: null,

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

1863: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1864: l_al_bal_val :=
1865: nvl(l_al_bal_val,0)
1866: +
1867: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1868: l_valid_asg_act_rec.assignment_action_id,
1869: g_employer_id,
1870: null,
1871: null,