DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_MX_EARN_EXEMPTION_RULES_F

Line 465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

461: AND pec.business_group_id IS NULL
462: AND pec.parent_classification_id IS NOT NULL
463: AND p_tax_type = 'STATE';
464:
465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

Line 466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;

462: AND pec.parent_classification_id IS NOT NULL
463: AND p_tax_type = 'STATE';
464:
465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

Line 467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;

463: AND p_tax_type = 'STATE';
464:
465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

Line 468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;

464:
465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
472: l_classification_name pay_element_classifications.classification_name%TYPE;

Line 469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

465: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
472: l_classification_name pay_element_classifications.classification_name%TYPE;
473: l_classification_id NUMBER;

Line 470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

466: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
472: l_classification_name pay_element_classifications.classification_name%TYPE;
473: l_classification_id NUMBER;
474: l_counter NUMBER;

Line 471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

467: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
468: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
469: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
470: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
471: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
472: l_classification_name pay_element_classifications.classification_name%TYPE;
473: l_classification_id NUMBER;
474: l_counter NUMBER;
475: l_proc_name VARCHAR2(100);

Line 520: FROM pay_mx_earn_exemption_rules_f pmex

516: -- Query to check if the classification is partially subject.
517: --
518: SELECT ''
519: INTO l_dummy
520: FROM pay_mx_earn_exemption_rules_f pmex
521: WHERE pmex.tax_type = p_tax_type
522: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
523: pmex.state_code) = p_ctx_jurisdiction_code
524: AND pmex.element_classification_id = l_classification_id

Line 630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;

626: AND pec.business_group_id IS NULL
627: AND pec.parent_classification_id IS NOT NULL
628: AND p_tax_type = 'STATE';
629:
630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;

Line 631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;

627: AND pec.parent_classification_id IS NOT NULL
628: AND p_tax_type = 'STATE';
629:
630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;

Line 632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;

628: AND p_tax_type = 'STATE';
629:
630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;

Line 633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;

629:
630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
637: l_classification_name pay_element_classifications.classification_name%type;

Line 634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;

630: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
637: l_classification_name pay_element_classifications.classification_name%type;
638: l_classification_id NUMBER;

Line 635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;

631: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
637: l_classification_name pay_element_classifications.classification_name%type;
638: l_classification_id NUMBER;
639: l_counter NUMBER;

Line 636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;

632: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
633: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
634: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
635: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
636: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
637: l_classification_name pay_element_classifications.classification_name%type;
638: l_classification_id NUMBER;
639: l_counter NUMBER;
640: l_proc_name VARCHAR2(100);

Line 685: FROM pay_mx_earn_exemption_rules_f pmex

681: -- Query to check if the classification is partially subject.
682: --
683: SELECT ''
684: INTO l_dummy
685: FROM pay_mx_earn_exemption_rules_f pmex
686: WHERE pmex.tax_type = p_tax_type
687: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
688: pmex.state_code) = p_ctx_jurisdiction_code
689: AND pmex.element_classification_id = l_classification_id

Line 795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

791: AND pec.business_group_id IS NULL
792: AND pec.parent_classification_id IS NOT NULL
793: AND p_tax_type = 'STATE';
794:
795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

Line 796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;

792: AND pec.parent_classification_id IS NOT NULL
793: AND p_tax_type = 'STATE';
794:
795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

Line 797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;

793: AND p_tax_type = 'STATE';
794:
795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

Line 798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;

794:
795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
802: l_classification_name pay_element_classifications.classification_name%TYPE;

Line 799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

795: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
802: l_classification_name pay_element_classifications.classification_name%TYPE;
803: l_classification_id NUMBER;

Line 800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

796: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
802: l_classification_name pay_element_classifications.classification_name%TYPE;
803: l_classification_id NUMBER;
804: l_counter NUMBER;

Line 801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

797: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
798: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
799: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
800: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
801: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
802: l_classification_name pay_element_classifications.classification_name%TYPE;
803: l_classification_id NUMBER;
804: l_counter NUMBER;
805: l_proc_name VARCHAR2(100);

Line 850: FROM pay_mx_earn_exemption_rules_f pmex

846: -- Query to check if the classification is partially subject.
847: --
848: SELECT ''
849: INTO l_dummy
850: FROM pay_mx_earn_exemption_rules_f pmex
851: WHERE pmex.tax_type = p_tax_type
852: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
853: pmex.state_code) = p_ctx_jurisdiction_code
854: AND pmex.element_classification_id = l_classification_id

Line 934: FROM pay_mx_earn_exemption_rules_f pmex

930: pmex.low_range_basis,
931: pmex.high_exempt_factor,
932: pmex.high_range_factor,
933: pmex.high_range_basis
934: FROM pay_mx_earn_exemption_rules_f pmex
935: WHERE pmex.tax_type = p_tax_type
936: AND DECODE(p_tax_type, 'ISR',
937: p_ctx_jurisdiction_code,
938: pmex.state_code) = p_ctx_jurisdiction_code

Line 1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

1006: AND paf.effective_end_date;
1007:
1008:
1009:
1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

Line 1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;

1007:
1008:
1009:
1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

Line 1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;

1008:
1009:
1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

Line 1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;

1009:
1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

Line 1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;

1010: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;

1011: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

Line 1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;

1012: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;