[Home] [Help]
653: and pec.classification_name = 'Involuntary Deductions';
654:
655: CURSOR csr_get_info is
656: select taxability_rules_date_id
657: from pay_taxability_rules_dates
658: where p_date_earned between valid_date_from and
659: valid_date_to
660: and legislation_code = 'US';
661:
700: l_cur_ele_tax_cat pay_element_types_f.element_information1%TYPE;
701: l_fed VARCHAR2(5);
702: l_state VARCHAR2(5);
703:
704: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
705: l_classification_id pay_element_classifications.classification_id%TYPE;
706: l_element_name pay_element_types_f.element_name%TYPE;
707: l_ip_val_name pay_input_values_f.name%TYPE;
708: l_value pay_element_entry_values_f.screen_entry_value%TYPE;