DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 959: from pay_us_federal_tax_info_f

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;

Line 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