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 3944: from pay_user_column_instances_f puci,

3940:
3941: -- VMKULKAR
3942: CURSOR c_get_state_garn_exemption_amt(p_column_name varchar2, p_row_name varchar2) IS
3943: select puci.value
3944: from pay_user_column_instances_f puci,
3945: pay_user_tables put,
3946: pay_user_rows_f pur,
3947: pay_user_columns puc
3948: where puci.user_column_id = puc.user_column_id

Line 5982: standard_deduction pay_user_column_instances_f.value%TYPE;

5978: c_fed_levy_xmpt_tab_col varchar2(100);
5979: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5980: c_federal_minimum_wage number;
5981: take_home_pay number;
5982: standard_deduction pay_user_column_instances_f.value%TYPE;
5983: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5984: personal_exemption_allowance number;
5985: fed_levy_annual_exemption number;
5986: fed_levy_exemption number;

Line 5983: allowance_per_exemption pay_user_column_instances_f.value%TYPE;

5979: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5980: c_federal_minimum_wage number;
5981: take_home_pay number;
5982: standard_deduction pay_user_column_instances_f.value%TYPE;
5983: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5984: personal_exemption_allowance number;
5985: fed_levy_annual_exemption number;
5986: fed_levy_exemption number;
5987: amt_at_hand number;

Line 6066: exemption_for_age_65_or_blind pay_user_column_instances_f.value%TYPE ;

6062: c_Fed_65_Blind_Xmpt_tab_col varchar2(100) ;
6063: lv_65_blind number ;
6064: lv_temp_Filing_Status varchar2(100) ;
6065: lv_Filing_Status_name varchar2(100) ;
6066: exemption_for_age_65_or_blind pay_user_column_instances_f.value%TYPE ;
6067:
6068: BEGIN
6069:
6070: l_proc_name := l_package_name||'CAL_FORMULA_TL';

Line 6567: ) RETURN pay_user_column_instances_f.value%TYPE IS

6563: C_FED_LEVY_EXEMPTION_TABLE varchar2,
6564: C_FED_LEVY_XMPT_TAB_COL varchar2,
6565: FILING_STATUS varchar2,
6566: FILING_STATUS_YEAR date
6567: ) RETURN pay_user_column_instances_f.value%TYPE IS
6568: BEGIN
6569: RETURN(hruserdt.get_table_value(
6570: CTX_BUSINESS_GROUP_ID,
6571: C_FED_LEVY_EXEMPTION_TABLE,