eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TAX_REG dependencies on PAY_BALANCE_TYPES

Line 245: p_balance_name IN pay_balance_types.balance_name%TYPE

241: -------------------------------------------------------------------------------
242: -- balance_id
243: -------------------------------------------------------------------------------
244: FUNCTION balance_id (
245: p_balance_name IN pay_balance_types.balance_name%TYPE
246: )
247: RETURN pay_balance_types.balance_type_id%TYPE
248: AS
249: ---------

Line 247: RETURN pay_balance_types.balance_type_id%TYPE

243: -------------------------------------------------------------------------------
244: FUNCTION balance_id (
245: p_balance_name IN pay_balance_types.balance_name%TYPE
246: )
247: RETURN pay_balance_types.balance_type_id%TYPE
248: AS
249: ---------
250: -- Cursor
251: ---------

Line 253: p_balance_name IN pay_balance_types.balance_name%TYPE

249: ---------
250: -- Cursor
251: ---------
252: CURSOR csr_balance_id (
253: p_balance_name IN pay_balance_types.balance_name%TYPE
254: )
255: IS
256: SELECT
257: pbt.balance_type_id

Line 259: pay_balance_types pbt

255: IS
256: SELECT
257: pbt.balance_type_id
258: FROM
259: pay_balance_types pbt
260: WHERE
261: pbt.balance_name = p_balance_name
262: AND pbt.business_group_id IS NULL
263: AND pbt.legislation_code = 'ZA';

Line 268: l_retval pay_balance_types.balance_type_id%TYPE;

264:
265: ------------
266: -- Variables
267: ------------
268: l_retval pay_balance_types.balance_type_id%TYPE;
269:
270: -------------------------------------------------------------------------------
271: BEGIN -- MAIN --
272: -------------------------------------------------------------------------------

Line 296: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

292: -------------------------------------------------------------------------------
293: FUNCTION ptd_value (
294: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
295: , p_action_period_id IN per_time_periods.time_period_id%TYPE
296: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
297: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
298: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
299: )
300: RETURN NUMBER AS

Line 357: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

353: -- mtd_value
354: -------------------------------------------------------------------------------
355: FUNCTION mtd_value (
356: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
357: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
358: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
359: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
360: )
361: RETURN NUMBER AS

Line 420: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

416: -- ytd_value
417: -------------------------------------------------------------------------------
418: FUNCTION ytd_value (
419: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
420: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
421: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
422: )
423: RETURN NUMBER AS
424: ------------

Line 790: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

786: AS
787: ------------
788: -- Variables
789: ------------
790: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
791: l_balance_value NUMBER;
792: -------------------------------------------------------------------------------
793: BEGIN -- MAIN --
794: -------------------------------------------------------------------------------

Line 2317: FROM pay_balance_types pbt

2313: SELECT DISTINCT
2314: pbt.balance_name bal_name
2315: , decode(pbt.balance_name,'Skills Levy',4142,4141) bal_code
2316: , pbt.balance_type_id bal_id
2317: FROM pay_balance_types pbt
2318: , pay_run_result_values prrv
2319: , pay_run_results prr
2320: , pay_balance_feeds_f feed
2321: , pay_payroll_actions ppa

Line 2340: FROM pay_balance_types pbt

2336: SELECT DISTINCT
2337: pbt.balance_name bal_name
2338: , decode(pbt.balance_name,'Skills Levy',4142,4141) bal_code
2339: , pbt.balance_type_id bal_id
2340: FROM pay_balance_types pbt
2341: WHERE pbt.balance_name in ('Skills Levy','UIF Employee Contribution','UIF Employer Contribution')
2342: AND pbt.legislation_code='ZA'; */
2343:
2344:

Line 2356: from pay_balance_types

2352: -----------------------------------------------------------
2353:
2354: Cursor csr_balance_type_id is
2355: select balance_type_id
2356: from pay_balance_types
2357: where balance_name = 'RFI Override SARS Reporting'
2358: and legislation_code = 'ZA' ;
2359:
2360: -----------------------------------------------------------

Line 2415: l_balance_type_id_rfi_override pay_balance_types.balance_type_id%TYPE;

2411: -- End Bug#13924112
2412: -- Bug 13717246
2413: -- RFI OVERRIDE FUNCTIONALITY FOR SARS REPORTING
2414:
2415: l_balance_type_id_rfi_override pay_balance_types.balance_type_id%TYPE;
2416: l_ptd_bal_rfi_override NUMBER;
2417: l_mtd_bal_rfi_override NUMBER;
2418: l_ytd_bal_rfi_override NUMBER;
2419: l_ptd_bal_rfi_code NUMBER;