APPS.PY_ZA_TX_01011001 dependencies on PAY_BALANCE_TYPES

Line 1625: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

1621: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1622:
1623: -- Variables
1624: --
1625: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1626: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1627: l_StrtDate DATE;
1628: l_EndDate DATE;
1629: l_NrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1626: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

1622:
1623: -- Variables
1624: --
1625: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1626: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1627: l_StrtDate DATE;
1628: l_EndDate DATE;
1629: l_NrfiYtd NUMBER(15,2) DEFAULT 0;
1630: l_CurNrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1644: FROM pay_balance_types

1640: BEGIN
1641: -- Retrieve Balance Type ID's
1642: SELECT balance_type_id
1643: INTO l_NrfiBalID
1644: FROM pay_balance_types
1645: WHERE legislation_code = 'ZA'
1646: AND balance_name = 'Travel Allowance NRFI';
1647:
1648: SELECT balance_type_id

Line 1650: FROM pay_balance_types

1646: AND balance_name = 'Travel Allowance NRFI';
1647:
1648: SELECT balance_type_id
1649: INTO l_RfiBalID
1650: FROM pay_balance_types
1651: WHERE legislation_code = 'ZA'
1652: AND balance_name = 'Travel Allowance RFI';
1653: -- Employee Tax Year Start and End Dates
1654: --

Line 1774: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

1770: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1771:
1772: -- Variables
1773: --
1774: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1775: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1776: l_StrtDate DATE;
1777: l_EndDate DATE;
1778: l_NrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1775: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

1771:
1772: -- Variables
1773: --
1774: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1775: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1776: l_StrtDate DATE;
1777: l_EndDate DATE;
1778: l_NrfiYtd NUMBER(15,2) DEFAULT 0;
1779: l_CurNrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1793: FROM pay_balance_types

1789: BEGIN
1790: -- Retrieve Balance Type ID's
1791: SELECT balance_type_id
1792: INTO l_NrfiBalID
1793: FROM pay_balance_types
1794: WHERE legislation_code = 'ZA'
1795: AND balance_name = 'Travel Allowance NRFI';
1796:
1797: SELECT balance_type_id

Line 1799: FROM pay_balance_types

1795: AND balance_name = 'Travel Allowance NRFI';
1796:
1797: SELECT balance_type_id
1798: INTO l_RfiBalID
1799: FROM pay_balance_types
1800: WHERE legislation_code = 'ZA'
1801: AND balance_name = 'Travel Allowance RFI';
1802:
1803: -- Employee Tax Year Start and End Dates