APPS.PY_ZA_TX_UTL_01032004 dependencies on PAY_BALANCE_TYPES

Line 2618: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

2614: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2615:
2616: -- Variables
2617: --
2618: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2619: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2620: l_StrtDate DATE;
2621: l_EndDate DATE;
2622: l_NrfiYtd t_balance DEFAULT 0;

Line 2619: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2615:
2616: -- Variables
2617: --
2618: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2619: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2620: l_StrtDate DATE;
2621: l_EndDate DATE;
2622: l_NrfiYtd t_balance DEFAULT 0;
2623: l_CurNrfiYtd t_balance DEFAULT 0;

Line 2639: FROM pay_balance_types

2635: hr_utility.set_location('py_za_tx_utl_01032004.TrvAll',1);
2636: -- Retrieve Balance Type ID's
2637: SELECT balance_type_id
2638: INTO l_NrfiBalID
2639: FROM pay_balance_types
2640: WHERE legislation_code = 'ZA'
2641: AND balance_name = 'Travel Allowance NRFI';
2642:
2643: hr_utility.set_location('py_za_tx_utl_01032004.TrvAll',2);

Line 2647: FROM pay_balance_types

2643: hr_utility.set_location('py_za_tx_utl_01032004.TrvAll',2);
2644:
2645: SELECT balance_type_id
2646: INTO l_RfiBalID
2647: FROM pay_balance_types
2648: WHERE legislation_code = 'ZA'
2649: AND balance_name = 'Travel Allowance RFI';
2650:
2651: -- Check Calc and setup correct values