APPS.PY_ZA_TX_UTL_01032000 dependencies on PAY_BALANCE_TYPES

Line 1478: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

1474: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1475:
1476: -- Variables
1477: --
1478: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1479: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1480: l_StrtDate DATE;
1481: l_EndDate DATE;
1482: l_NrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1479: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

1475:
1476: -- Variables
1477: --
1478: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
1479: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
1480: l_StrtDate DATE;
1481: l_EndDate DATE;
1482: l_NrfiYtd NUMBER(15,2) DEFAULT 0;
1483: l_CurNrfiYtd NUMBER(15,2) DEFAULT 0;

Line 1499: FROM pay_balance_types

1495: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',1);
1496: -- Retrieve Balance Type ID's
1497: SELECT balance_type_id
1498: INTO l_NrfiBalID
1499: FROM pay_balance_types
1500: WHERE legislation_code = 'ZA'
1501: AND balance_name = 'Travel Allowance NRFI';
1502:
1503: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',2);

Line 1507: FROM pay_balance_types

1503: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',2);
1504:
1505: SELECT balance_type_id
1506: INTO l_RfiBalID
1507: FROM pay_balance_types
1508: WHERE legislation_code = 'ZA'
1509: AND balance_name = 'Travel Allowance RFI';
1510:
1511: -- Check Calc and setup correct values