eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 3278: from pay_user_column_instances_f puci,

3274:
3275: -- VMKULKAR
3276: CURSOR c_get_state_garn_exemption_amt(p_column_name varchar2, p_row_name varchar2) IS
3277: select puci.value
3278: from pay_user_column_instances_f puci,
3279: pay_user_tables put,
3280: pay_user_rows_f pur,
3281: pay_user_columns puc
3282: where puci.user_column_id = puc.user_column_id

Line 5116: standard_deduction pay_user_column_instances_f.value%TYPE;

5112: c_fed_levy_xmpt_tab_col varchar2(100);
5113: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5114: c_federal_minimum_wage number;
5115: take_home_pay number;
5116: standard_deduction pay_user_column_instances_f.value%TYPE;
5117: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5118: personal_exemption_allowance number;
5119: fed_levy_annual_exemption number;
5120: fed_levy_exemption number;

Line 5117: allowance_per_exemption pay_user_column_instances_f.value%TYPE;

5113: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5114: c_federal_minimum_wage number;
5115: take_home_pay number;
5116: standard_deduction pay_user_column_instances_f.value%TYPE;
5117: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5118: personal_exemption_allowance number;
5119: fed_levy_annual_exemption number;
5120: fed_levy_exemption number;
5121: amt_at_hand number;

Line 5200: exemption_for_age_65_or_blind pay_user_column_instances_f.value%TYPE ;

5196: c_Fed_65_Blind_Xmpt_tab_col varchar2(100) ;
5197: lv_65_blind number ;
5198: lv_temp_Filing_Status varchar2(100) ;
5199: lv_Filing_Status_name varchar2(100) ;
5200: exemption_for_age_65_or_blind pay_user_column_instances_f.value%TYPE ;
5201:
5202: BEGIN
5203:
5204: l_proc_name := l_package_name||'CAL_FORMULA_TL';

Line 5690: ) RETURN pay_user_column_instances_f.value%TYPE IS

5686: C_FED_LEVY_EXEMPTION_TABLE varchar2,
5687: C_FED_LEVY_XMPT_TAB_COL varchar2,
5688: FILING_STATUS varchar2,
5689: FILING_STATUS_YEAR date
5690: ) RETURN pay_user_column_instances_f.value%TYPE IS
5691: BEGIN
5692: RETURN(hruserdt.get_table_value(
5693: CTX_BUSINESS_GROUP_ID,
5694: C_FED_LEVY_EXEMPTION_TABLE,