955: transaction_value_fs VARCHAR2(80);
956:
957: CURSOR c_fed_allowance_limit is
958: select fed_information1
959: from pay_us_federal_tax_info_f
960: where fed_information_category = 'ALLOWANCES LIMIT'
961: and trunc(sysdate) between effective_start_date and effective_end_date;
962:
963: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
959: from pay_us_federal_tax_info_f
960: where fed_information_category = 'ALLOWANCES LIMIT'
961: and trunc(sysdate) between effective_start_date and effective_end_date;
962:
963: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
964:
965: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
966: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
967: select fff.function_id, fff.function_name