392: AND pec.business_group_id IS NULL
393: AND pec.parent_classification_id IS NOT NULL
394: AND p_tax_type = 'STATE';
395:
396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
393: AND pec.parent_classification_id IS NOT NULL
394: AND p_tax_type = 'STATE';
395:
396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
394: AND p_tax_type = 'STATE';
395:
396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
395:
396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
403: l_classification_name pay_element_classifications.classification_name%TYPE;
396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
403: l_classification_name pay_element_classifications.classification_name%TYPE;
404: l_classification_id NUMBER;
397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
403: l_classification_name pay_element_classifications.classification_name%TYPE;
404: l_classification_id NUMBER;
405: l_counter NUMBER;
398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
403: l_classification_name pay_element_classifications.classification_name%TYPE;
404: l_classification_id NUMBER;
405: l_counter NUMBER;
406: l_proc_name VARCHAR2(100);
447: -- Query to check if the classification is partially subject.
448: --
449: SELECT ''
450: INTO l_dummy
451: FROM pay_mx_earn_exemption_rules_f pmex
452: WHERE pmex.tax_type = p_tax_type
453: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
454: pmex.state_code) = p_ctx_jurisdiction_code
455: AND pmex.element_classification_id = l_classification_id
557: AND pec.business_group_id IS NULL
558: AND pec.parent_classification_id IS NOT NULL
559: AND p_tax_type = 'STATE';
560:
561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
558: AND pec.parent_classification_id IS NOT NULL
559: AND p_tax_type = 'STATE';
560:
561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
559: AND p_tax_type = 'STATE';
560:
561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
560:
561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
568: l_classification_name pay_element_classifications.classification_name%type;
561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
568: l_classification_name pay_element_classifications.classification_name%type;
569: l_classification_id NUMBER;
562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%type;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
568: l_classification_name pay_element_classifications.classification_name%type;
569: l_classification_id NUMBER;
570: l_counter NUMBER;
563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%type;
564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%type;
565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%type;
566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%type;
567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%type;
568: l_classification_name pay_element_classifications.classification_name%type;
569: l_classification_id NUMBER;
570: l_counter NUMBER;
571: l_proc_name VARCHAR2(100);
612: -- Query to check if the classification is partially subject.
613: --
614: SELECT ''
615: INTO l_dummy
616: FROM pay_mx_earn_exemption_rules_f pmex
617: WHERE pmex.tax_type = p_tax_type
618: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
619: pmex.state_code) = p_ctx_jurisdiction_code
620: AND pmex.element_classification_id = l_classification_id
722: AND pec.business_group_id IS NULL
723: AND pec.parent_classification_id IS NOT NULL
724: AND p_tax_type = 'STATE';
725:
726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
723: AND pec.parent_classification_id IS NOT NULL
724: AND p_tax_type = 'STATE';
725:
726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
724: AND p_tax_type = 'STATE';
725:
726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
725:
726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
733: l_classification_name pay_element_classifications.classification_name%TYPE;
726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
733: l_classification_name pay_element_classifications.classification_name%TYPE;
734: l_classification_id NUMBER;
727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
733: l_classification_name pay_element_classifications.classification_name%TYPE;
734: l_classification_id NUMBER;
735: l_counter NUMBER;
728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
733: l_classification_name pay_element_classifications.classification_name%TYPE;
734: l_classification_id NUMBER;
735: l_counter NUMBER;
736: l_proc_name VARCHAR2(100);
777: -- Query to check if the classification is partially subject.
778: --
779: SELECT ''
780: INTO l_dummy
781: FROM pay_mx_earn_exemption_rules_f pmex
782: WHERE pmex.tax_type = p_tax_type
783: AND DECODE(p_tax_type, 'ISR', p_ctx_jurisdiction_code,
784: pmex.state_code) = p_ctx_jurisdiction_code
785: AND pmex.element_classification_id = l_classification_id
861: pmex.low_range_basis,
862: pmex.high_exempt_factor,
863: pmex.high_range_factor,
864: pmex.high_range_basis
865: FROM pay_mx_earn_exemption_rules_f pmex
866: WHERE pmex.tax_type = p_tax_type
867: AND DECODE(p_tax_type, 'ISR',
868: p_ctx_jurisdiction_code,
869: pmex.state_code) = p_ctx_jurisdiction_code
915: WHERE paf.assignment_id = cp_assignment_id
916: AND cp_effective_date BETWEEN paf.effective_start_date
917: AND paf.effective_end_date;
918:
919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
916: AND cp_effective_date BETWEEN paf.effective_start_date
917: AND paf.effective_end_date;
918:
919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
917: AND paf.effective_end_date;
918:
919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
918:
919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_exempt_factor%TYPE;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_range_factor%TYPE;
922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;