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 416: RETURN pay_run_result_values.result_value%TYPE

412: , p_value_name IN pay_input_values_f.name%TYPE
413: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
414: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
415: )
416: RETURN pay_run_result_values.result_value%TYPE
417: AS
418: ---------
419: -- Cursor
420: ---------

Line 430: , pay_run_result_values prrv

426: FROM
427: pay_element_types_f pet
428: , pay_input_values_f piv
429: , pay_run_results prr
430: , pay_run_result_values prrv
431: WHERE
432: pet.element_name = p_element_name
433: AND pet.legislation_code = 'ZA'
434: AND pet.element_type_id = piv.element_type_id

Line 490: RETURN pay_run_result_values.result_value%TYPE

486: FUNCTION run_result_value (
487: p_value_name IN pay_input_values_f.name%TYPE
488: , p_run_result_id IN pay_run_results.run_result_id%TYPE
489: )
490: RETURN pay_run_result_values.result_value%TYPE
491: AS
492: ---------
493: -- Cursor
494: ---------

Line 502: , pay_run_result_values prrv

498: prrv.result_value
499: FROM
500: pay_run_results prr
501: , pay_input_values_f piv
502: , pay_run_result_values prrv
503: WHERE
504: prr.run_result_id = p_run_result_id
505: AND prr.element_type_id = piv.element_type_id
506: AND piv.name = p_value_name

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

579: -------------------------------------------------------------------------------
580: PROCEDURE assignment_tax_sta_dir (
581: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
582: , p_asg_tax_status OUT NOCOPY hr_lookups.meaning%TYPE
583: , p_asg_dir_value OUT NOCOPY pay_run_result_values.result_value%TYPE
584: , p_asg_tax_status_code OUT NOCOPY hr_lookups.lookup_code%TYPE
585: )
586: AS
587: ------------

Line 591: l_dir_value pay_run_result_values.result_value%TYPE;

587: ------------
588: -- Variables
589: ------------
590: l_tax_status hr_lookups.meaning%TYPE;
591: l_dir_value pay_run_result_values.result_value%TYPE;
592: l_run_result_id pay_run_results.run_result_id%TYPE;
593: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
594:
595: -------------------------------------------------------------------------------

Line 1501: , pay_run_result_values prrv

1497: pbc.full_balance_name bal_name
1498: , pbc.code bal_code
1499: , pbc.balance_type_id bal_id
1500: FROM pay_za_irp5_bal_codes pbc
1501: , pay_run_result_values prrv
1502: , pay_run_results prr
1503: , pay_balance_feeds_f feed
1504: , pay_payroll_actions ppa
1505: , pay_assignment_actions paa

Line 1522: l_asg_tax_status pay_run_result_values.result_value%TYPE;

1518: -- Variables
1519: ------------
1520: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1521: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1522: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1523: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1524: l_asg_dys_worked NUMBER;
1525: l_ptd_bal NUMBER;
1526: l_mtd_bal NUMBER;

Line 1523: l_asg_dir_value pay_run_result_values.result_value%TYPE;

1519: ------------
1520: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1521: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1522: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1523: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1524: l_asg_dys_worked NUMBER;
1525: l_ptd_bal NUMBER;
1526: l_mtd_bal NUMBER;
1527: l_ytd_bal NUMBER;