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_RUN_RESULT_VALUES

Line 473: RETURN pay_run_result_values.result_value%TYPE

469: , p_value_name IN pay_input_values_f.name%TYPE
470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
471: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
472: )
473: RETURN pay_run_result_values.result_value%TYPE
474: AS
475: ---------
476: -- Cursor
477: ---------

Line 487: , pay_run_result_values prrv

483: FROM
484: pay_element_types_f pet
485: , pay_input_values_f piv
486: , pay_run_results prr
487: , pay_run_result_values prrv
488: WHERE
489: pet.element_name = p_element_name
490: AND pet.legislation_code = 'ZA'
491: AND pet.element_type_id = piv.element_type_id

Line 547: RETURN pay_run_result_values.result_value%TYPE

543: FUNCTION run_result_value (
544: p_value_name IN pay_input_values_f.name%TYPE
545: , p_run_result_id IN pay_run_results.run_result_id%TYPE
546: )
547: RETURN pay_run_result_values.result_value%TYPE
548: AS
549: ---------
550: -- Cursor
551: ---------

Line 559: , pay_run_result_values prrv

555: prrv.result_value
556: FROM
557: pay_run_results prr
558: , pay_input_values_f piv
559: , pay_run_result_values prrv
560: WHERE
561: prr.run_result_id = p_run_result_id
562: AND prr.element_type_id = piv.element_type_id
563: AND piv.name = p_value_name

Line 640: , p_asg_dir_value OUT NOCOPY pay_run_result_values.result_value%TYPE

636: -------------------------------------------------------------------------------
637: PROCEDURE assignment_tax_sta_dir (
638: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
639: , p_asg_tax_status OUT NOCOPY hr_lookups.meaning%TYPE
640: , p_asg_dir_value OUT NOCOPY pay_run_result_values.result_value%TYPE
641: , p_asg_tax_status_code OUT NOCOPY hr_lookups.lookup_code%TYPE
642: )
643: AS
644: ------------

Line 648: l_dir_value pay_run_result_values.result_value%TYPE;

644: ------------
645: -- Variables
646: ------------
647: l_tax_status hr_lookups.meaning%TYPE;
648: l_dir_value pay_run_result_values.result_value%TYPE;
649: l_run_result_id pay_run_results.run_result_id%TYPE;
650: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
651:
652: -------------------------------------------------------------------------------

Line 1584: , pay_run_result_values prrv

1580: pbc.full_balance_name bal_name
1581: , pbc.code bal_code
1582: , pbc.balance_type_id bal_id
1583: FROM pay_za_irp5_bal_codes pbc
1584: , pay_run_result_values prrv
1585: , pay_run_results prr
1586: , pay_balance_feeds_f feed
1587: , pay_payroll_actions ppa
1588: , pay_assignment_actions paa

Line 1608: l_asg_tax_status pay_run_result_values.result_value%TYPE;

1604: -- Variables
1605: ------------
1606: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1607: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1608: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1609: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1610: l_asg_dys_worked NUMBER;
1611: l_ptd_bal NUMBER;
1612: l_mtd_bal NUMBER;

Line 1609: l_asg_dir_value pay_run_result_values.result_value%TYPE;

1605: ------------
1606: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1607: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1608: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1609: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1610: l_asg_dys_worked NUMBER;
1611: l_ptd_bal NUMBER;
1612: l_mtd_bal NUMBER;
1613: l_ytd_bal NUMBER;

Line 2289: , pay_run_result_values prrv

2285: pbc.balance_name bal_name
2286: , pbc.code bal_code
2287: , pbc.balance_type_id bal_id
2288: FROM pay_za_irp5_bal_codes pbc
2289: , pay_run_result_values prrv
2290: , pay_run_results prr
2291: , pay_balance_feeds_f feed
2292: , pay_payroll_actions ppa
2293: , pay_assignment_actions paa

Line 2318: , pay_run_result_values prrv

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
2322: , pay_assignment_actions paa

Line 2384: l_asg_tax_status pay_run_result_values.result_value%TYPE;

2380: -- Variables
2381: ------------
2382: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
2383: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
2384: l_asg_tax_status pay_run_result_values.result_value%TYPE;
2385: l_asg_dir_value pay_run_result_values.result_value%TYPE;
2386: l_asg_dys_worked NUMBER;
2387: l_ptd_bal NUMBER;
2388: l_mtd_bal NUMBER;

Line 2385: l_asg_dir_value pay_run_result_values.result_value%TYPE;

2381: ------------
2382: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
2383: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
2384: l_asg_tax_status pay_run_result_values.result_value%TYPE;
2385: l_asg_dir_value pay_run_result_values.result_value%TYPE;
2386: l_asg_dys_worked NUMBER;
2387: l_ptd_bal NUMBER;
2388: l_mtd_bal NUMBER;
2389: l_ytd_bal NUMBER;