823: transaction_value_fs VARCHAR2(80);
824:
825: CURSOR c_fed_allowance_limit is
826: select fed_information1
827: from pay_us_federal_tax_info_f
828: where fed_information_category = 'ALLOWANCES LIMIT'
829: and trunc(sysdate) between effective_start_date and effective_end_date;
830:
831: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
827: from pay_us_federal_tax_info_f
828: where fed_information_category = 'ALLOWANCES LIMIT'
829: and trunc(sysdate) between effective_start_date and effective_end_date;
830:
831: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
832:
833: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
834: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
835: select fff.function_id, fff.function_name