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.HR_USER_INIT_DEDN dependencies on PAY_ALL_DEDUCTION_TYPES_V

Line 4752: FROM pay_all_deduction_types_v

4748: p_ele_standard_link in varchar2 default 'N') IS
4749:
4750: CURSOR chk_for_lock IS
4751: SELECT *
4752: FROM pay_all_deduction_types_v
4753: WHERE element_type_id = p_ele_type_id;
4754: -- FOR UPDATE OF element_type_id NOWAIT;
4755:
4756: recinfo chk_for_lock%ROWTYPE;

Line 4965: from pay_all_deduction_types_v

4961:
4962: --Begin
4963: select employer_match_flag, aftertax_component_flag, classification_name
4964: into v_employer_match_flag, v_after_tax_flag, v_class_name
4965: from pay_all_deduction_types_v
4966: where element_type_id = p_ele_type_id
4967: and v_del_sess_date >= effective_start_date
4968: and v_del_sess_date <= effective_end_date
4969: and business_group_id + 0 = p_business_group_id ;

Line 5066: from pay_all_deduction_types_v padt,

5062: not_taken_baltype_id, tobondpurch_baltype_id,
5063: additional_baltype_id, replacement_baltype_id
5064: into v_at_bal_id, v_at_accr_id, v_at_arr_id, v_at_not_taken_id,
5065: v_at_to_bond_id, v_at_addl_id, v_at_repl_id
5066: from pay_all_deduction_types_v padt,
5067: pay_element_types_f pet
5068: WHERE pet.element_type_id = padt.element_type_id
5069: AND padt.element_name like p_ele_name||' AT'
5070: AND v_del_sess_date >= padt.effective_start_date