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 HR_LOOKUPS

Line 57: instead of hr_lookups

53: A. Mahanty 14/04/2005 115.21 3491357 BRA Enh. Balance Value retrieval
54: modified.
55: J.N. Louw 23/06/2004 115.20 3694450 Modified assignment_nature
56: to reference fnd_lookup_values
57: instead of hr_lookups
58: R. Pahune 09/02/2004 115.19 3400581 Modified the cursor
59: csr_processed_assignments.
60: N. Venugopal 09/01/2004 115.18 3221746 removed set serverout on for gscc compliance.
61: N. Venugopal 07/01/2004 115.17 3221746 Code changes for performace improvement.

Line 594: p_lookup_type IN hr_lookups.lookup_type%TYPE

590: -------------------------------------------------------------------------------
591: -- decode_lookup_code
592: -------------------------------------------------------------------------------
593: FUNCTION decode_lookup_code (
594: p_lookup_type IN hr_lookups.lookup_type%TYPE
595: , p_lookup_code IN hr_lookups.lookup_code%TYPE
596: , p_application_id IN hr_lookups.application_id%TYPE
597: )
598: RETURN hr_lookups.meaning%TYPE AS

Line 595: , p_lookup_code IN hr_lookups.lookup_code%TYPE

591: -- decode_lookup_code
592: -------------------------------------------------------------------------------
593: FUNCTION decode_lookup_code (
594: p_lookup_type IN hr_lookups.lookup_type%TYPE
595: , p_lookup_code IN hr_lookups.lookup_code%TYPE
596: , p_application_id IN hr_lookups.application_id%TYPE
597: )
598: RETURN hr_lookups.meaning%TYPE AS
599: ---------

Line 596: , p_application_id IN hr_lookups.application_id%TYPE

592: -------------------------------------------------------------------------------
593: FUNCTION decode_lookup_code (
594: p_lookup_type IN hr_lookups.lookup_type%TYPE
595: , p_lookup_code IN hr_lookups.lookup_code%TYPE
596: , p_application_id IN hr_lookups.application_id%TYPE
597: )
598: RETURN hr_lookups.meaning%TYPE AS
599: ---------
600: -- Cursor

Line 598: RETURN hr_lookups.meaning%TYPE AS

594: p_lookup_type IN hr_lookups.lookup_type%TYPE
595: , p_lookup_code IN hr_lookups.lookup_code%TYPE
596: , p_application_id IN hr_lookups.application_id%TYPE
597: )
598: RETURN hr_lookups.meaning%TYPE AS
599: ---------
600: -- Cursor
601: ---------
602: CURSOR csr_lookup_meaning

Line 605: FROM hr_lookups hl

601: ---------
602: CURSOR csr_lookup_meaning
603: IS
604: SELECT hl.meaning
605: FROM hr_lookups hl
606: WHERE hl.lookup_type = p_lookup_type
607: AND hl.lookup_code = p_lookup_code
608: AND hl.application_id = p_application_id;
609: --

Line 613: l_meaning hr_lookups.meaning%TYPE;

609: --
610: ------------
611: -- Variables
612: ------------
613: l_meaning hr_lookups.meaning%TYPE;
614: --
615: -------------------------------------------------------------------------------
616: BEGIN -- MAIN --
617: -------------------------------------------------------------------------------

Line 639: , p_asg_tax_status OUT NOCOPY hr_lookups.meaning%TYPE

635: -- assignment_tax_status_directive
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

Line 641: , p_asg_tax_status_code OUT NOCOPY hr_lookups.lookup_code%TYPE

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: ------------
645: -- Variables

Line 647: l_tax_status hr_lookups.meaning%TYPE;

643: AS
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:

Line 650: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;

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: -------------------------------------------------------------------------------
653: BEGIN -- MAIN --
654: -------------------------------------------------------------------------------

Line 706: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE

702: -------------------------------------------------------------------------------
703: PROCEDURE assignment_nature (
704: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
705: , p_effective_date IN DATE
706: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
707: )
708: AS
709: ------------
710: -- Variables

Line 742: l_nature hr_lookups.meaning%TYPE;

738: AND fcl.lookup_code(+) = aei.aei_information4
739: AND fcl.language(+) = 'US';
740:
741:
742: l_nature hr_lookups.meaning%TYPE;
743:
744: -------------------------------------------------------------------------------
745: BEGIN -- MAIN --
746: -------------------------------------------------------------------------------

Line 781: p_asg_tax_status IN hr_lookups.meaning%TYPE

777: -------------------------------------------------------------------------------
778: -- assignment_dys_worked
779: -------------------------------------------------------------------------------
780: FUNCTION assignment_dys_worked (
781: p_asg_tax_status IN hr_lookups.meaning%TYPE
782: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
783: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
784: )
785: RETURN NUMBER

Line 1614: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;

1610: l_asg_dys_worked NUMBER;
1611: l_ptd_bal NUMBER;
1612: l_mtd_bal NUMBER;
1613: l_ytd_bal NUMBER;
1614: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1615: l_nature hr_lookups.meaning%TYPE;
1616: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1617:
1618: l_ovn number; -- bug 13444804

Line 1615: l_nature hr_lookups.meaning%TYPE;

1611: l_ptd_bal NUMBER;
1612: l_mtd_bal NUMBER;
1613: l_ytd_bal NUMBER;
1614: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1615: l_nature hr_lookups.meaning%TYPE;
1616: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1617:
1618: l_ovn number; -- bug 13444804
1619: l_action_id number; -- bug 13444804

Line 1906: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE

1902: -------------------------------------------------------------------------------
1903: PROCEDURE assignment_nature_01032009 (
1904: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1905: , p_effective_date IN DATE
1906: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
1907: , p_foreign_income OUT NOCOPY varchar2
1908: )
1909: AS
1910: ------------

Line 1944: l_nature hr_lookups.meaning%TYPE;

1940: AND fcl.lookup_code(+) = aei.aei_information4
1941: AND fcl.language(+) = 'US';
1942:
1943:
1944: l_nature hr_lookups.meaning%TYPE;
1945:
1946: -------------------------------------------------------------------------------
1947: BEGIN -- MAIN --
1948: -------------------------------------------------------------------------------

Line 2030: from hr_lookups

2026: PROCEDURE fetch_code_desc as
2027: cursor csr_code_desc is
2028: select lookup_code code,
2029: description code_desc
2030: from hr_lookups
2031: where application_id = 800
2032: and lookup_type = 'ZA_SARS_CODE_DESCRIPTIONS';
2033: -------------------------------------------------------------------------------
2034: BEGIN --

Line 2390: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;

2386: l_asg_dys_worked NUMBER;
2387: l_ptd_bal NUMBER;
2388: l_mtd_bal NUMBER;
2389: l_ytd_bal NUMBER;
2390: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
2391: l_nature hr_lookups.meaning%TYPE;
2392: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
2393: t_code_val code_value_table;
2394: l_code pay_za_irp5_bal_codes.code%TYPE;

Line 2391: l_nature hr_lookups.meaning%TYPE;

2387: l_ptd_bal NUMBER;
2388: l_mtd_bal NUMBER;
2389: l_ytd_bal NUMBER;
2390: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
2391: l_nature hr_lookups.meaning%TYPE;
2392: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
2393: t_code_val code_value_table;
2394: l_code pay_za_irp5_bal_codes.code%TYPE;
2395: l_asg_foreign_income varchar2(1);