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;
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;
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;
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;
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;
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;
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);
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
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;
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;
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;
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;
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;
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;
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);
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
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;
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;
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;
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;
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;
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;
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);
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
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
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;
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;
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;
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;
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;
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;
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;