DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 827: from pay_us_federal_tax_info_f

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;

Line 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