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 21: instead of hr_lookups

17: A. Mahanty 14/04/2005 115.21 3491357 BRA Enh. Balance Value retrieval
18: modified.
19: J.N. Louw 23/06/2004 115.20 3694450 Modified assignment_nature
20: to reference fnd_lookup_values
21: instead of hr_lookups
22: R. Pahune 09/02/2004 115.19 3400581 Modified the cursor
23: csr_processed_assignments.
24: N. Venugopal 09/01/2004 115.18 3221746 removed set serverout on for gscc compliance.
25: N. Venugopal 07/01/2004 115.17 3221746 Code changes for performace improvement.

Line 537: p_lookup_type IN hr_lookups.lookup_type%TYPE

533: -------------------------------------------------------------------------------
534: -- decode_lookup_code
535: -------------------------------------------------------------------------------
536: FUNCTION decode_lookup_code (
537: p_lookup_type IN hr_lookups.lookup_type%TYPE
538: , p_lookup_code IN hr_lookups.lookup_code%TYPE
539: , p_application_id IN hr_lookups.application_id%TYPE
540: )
541: RETURN hr_lookups.meaning%TYPE AS

Line 538: , p_lookup_code IN hr_lookups.lookup_code%TYPE

534: -- decode_lookup_code
535: -------------------------------------------------------------------------------
536: FUNCTION decode_lookup_code (
537: p_lookup_type IN hr_lookups.lookup_type%TYPE
538: , p_lookup_code IN hr_lookups.lookup_code%TYPE
539: , p_application_id IN hr_lookups.application_id%TYPE
540: )
541: RETURN hr_lookups.meaning%TYPE AS
542: ---------

Line 539: , p_application_id IN hr_lookups.application_id%TYPE

535: -------------------------------------------------------------------------------
536: FUNCTION decode_lookup_code (
537: p_lookup_type IN hr_lookups.lookup_type%TYPE
538: , p_lookup_code IN hr_lookups.lookup_code%TYPE
539: , p_application_id IN hr_lookups.application_id%TYPE
540: )
541: RETURN hr_lookups.meaning%TYPE AS
542: ---------
543: -- Cursor

Line 541: RETURN hr_lookups.meaning%TYPE AS

537: p_lookup_type IN hr_lookups.lookup_type%TYPE
538: , p_lookup_code IN hr_lookups.lookup_code%TYPE
539: , p_application_id IN hr_lookups.application_id%TYPE
540: )
541: RETURN hr_lookups.meaning%TYPE AS
542: ---------
543: -- Cursor
544: ---------
545: CURSOR csr_lookup_meaning

Line 548: FROM hr_lookups hl

544: ---------
545: CURSOR csr_lookup_meaning
546: IS
547: SELECT hl.meaning
548: FROM hr_lookups hl
549: WHERE hl.lookup_type = p_lookup_type
550: AND hl.lookup_code = p_lookup_code
551: AND hl.application_id = p_application_id;
552: --

Line 556: l_meaning hr_lookups.meaning%TYPE;

552: --
553: ------------
554: -- Variables
555: ------------
556: l_meaning hr_lookups.meaning%TYPE;
557: --
558: -------------------------------------------------------------------------------
559: BEGIN -- MAIN --
560: -------------------------------------------------------------------------------

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

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

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

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

Line 590: l_tax_status hr_lookups.meaning%TYPE;

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

Line 593: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;

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: -------------------------------------------------------------------------------
596: BEGIN -- MAIN --
597: -------------------------------------------------------------------------------

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

645: -------------------------------------------------------------------------------
646: PROCEDURE assignment_nature (
647: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
648: , p_effective_date IN DATE
649: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
650: )
651: AS
652: ------------
653: -- Variables

Line 685: l_nature hr_lookups.meaning%TYPE;

681: AND fcl.lookup_code(+) = aei.aei_information4
682: AND fcl.language(+) = 'US';
683:
684:
685: l_nature hr_lookups.meaning%TYPE;
686:
687: -------------------------------------------------------------------------------
688: BEGIN -- MAIN --
689: -------------------------------------------------------------------------------

Line 724: p_asg_tax_status IN hr_lookups.meaning%TYPE

720: -------------------------------------------------------------------------------
721: -- assignment_dys_worked
722: -------------------------------------------------------------------------------
723: FUNCTION assignment_dys_worked (
724: p_asg_tax_status IN hr_lookups.meaning%TYPE
725: , p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
726: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
727: )
728: RETURN NUMBER

Line 1528: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;

1524: l_asg_dys_worked NUMBER;
1525: l_ptd_bal NUMBER;
1526: l_mtd_bal NUMBER;
1527: l_ytd_bal NUMBER;
1528: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1529: l_nature hr_lookups.meaning%TYPE;
1530: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1531:
1532: -------------------------------------------------------------------------------

Line 1529: l_nature hr_lookups.meaning%TYPE;

1525: l_ptd_bal NUMBER;
1526: l_mtd_bal NUMBER;
1527: l_ytd_bal NUMBER;
1528: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1529: l_nature hr_lookups.meaning%TYPE;
1530: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1531:
1532: -------------------------------------------------------------------------------
1533: BEGIN -- Pre Process - MAIN --