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 4876: FROM pay_all_deduction_types_v

4872: p_ele_standard_link in varchar2 default 'N') IS
4873:
4874: CURSOR chk_for_lock IS
4875: SELECT *
4876: FROM pay_all_deduction_types_v
4877: WHERE element_type_id = p_ele_type_id;
4878: -- FOR UPDATE OF element_type_id NOWAIT;
4879:
4880: recinfo chk_for_lock%ROWTYPE;

Line 5091: from pay_all_deduction_types_v

5087:
5088: --Begin
5089: select employer_match_flag, aftertax_component_flag, classification_name
5090: into v_employer_match_flag, v_after_tax_flag, v_class_name
5091: from pay_all_deduction_types_v
5092: where element_type_id = p_ele_type_id
5093: and v_del_sess_date >= effective_start_date
5094: and v_del_sess_date <= effective_end_date
5095: and business_group_id + 0 = p_business_group_id ;

Line 5192: from pay_all_deduction_types_v padt,

5188: not_taken_baltype_id, tobondpurch_baltype_id,
5189: additional_baltype_id, replacement_baltype_id
5190: into v_at_bal_id, v_at_accr_id, v_at_arr_id, v_at_not_taken_id,
5191: v_at_to_bond_id, v_at_addl_id, v_at_repl_id
5192: from pay_all_deduction_types_v padt,
5193: pay_element_types_f pet
5194: WHERE pet.element_type_id = padt.element_type_id
5195: AND padt.element_name like p_ele_name||' AT'
5196: AND v_del_sess_date >= padt.effective_start_date