DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_MX_EARN_EXEMPTION_RULES_F

Line 396: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

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;

Line 397: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_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;

Line 398: l_low_range_factor pay_mx_earn_exemption_rules_f.low_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;

Line 399: l_low_range_basis pay_mx_earn_exemption_rules_f.low_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;

Line 400: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%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;

Line 401: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%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;
405: l_counter NUMBER;

Line 402: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%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;
406: l_proc_name VARCHAR2(100);

Line 451: FROM pay_mx_earn_exemption_rules_f pmex

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

Line 561: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%type;

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;

Line 562: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_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;

Line 563: l_low_range_factor pay_mx_earn_exemption_rules_f.low_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;

Line 564: l_low_range_basis pay_mx_earn_exemption_rules_f.low_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;

Line 565: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%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;

Line 566: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%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;
570: l_counter NUMBER;

Line 567: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%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;
571: l_proc_name VARCHAR2(100);

Line 616: FROM pay_mx_earn_exemption_rules_f pmex

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

Line 726: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

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;

Line 727: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_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;

Line 728: l_low_range_factor pay_mx_earn_exemption_rules_f.low_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;

Line 729: l_low_range_basis pay_mx_earn_exemption_rules_f.low_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;

Line 730: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%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;

Line 731: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%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;
735: l_counter NUMBER;

Line 732: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%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;
736: l_proc_name VARCHAR2(100);

Line 781: FROM pay_mx_earn_exemption_rules_f pmex

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

Line 865: FROM pay_mx_earn_exemption_rules_f pmex

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

Line 919: l_calc_rule pay_mx_earn_exemption_rules_f.calc_rule%TYPE;

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;

Line 920: l_low_exempt_factor pay_mx_earn_exemption_rules_f.low_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;

Line 921: l_low_range_factor pay_mx_earn_exemption_rules_f.low_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;

Line 922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_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;

Line 923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%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;

Line 924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%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;

Line 925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%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;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;