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_USER_INIT_DEDN dependencies on PAY_ELEMENT_TYPES_F

Line 169: l_srs_ercontr_type_id pay_element_types_f.element_type_id%type;

165: l_element_information_category varchar2(30);
166: l_fees_core_element_type_id number(9);
167: l_inv_ded varchar2(22);
168: l_accr_fees_bal_id number(9);
169: l_srs_ercontr_type_id pay_element_types_f.element_type_id%type;
170: l_srs_ercontr_obj_ver_number pay_element_types_f.object_version_number%type;
171: l_srs_ercontr_rep_name pay_element_types_f.reporting_name%type;
172: l_srs_ercontr_desc_name pay_element_types_f.description%type;
173: -- USERRA Changes

Line 170: l_srs_ercontr_obj_ver_number pay_element_types_f.object_version_number%type;

166: l_fees_core_element_type_id number(9);
167: l_inv_ded varchar2(22);
168: l_accr_fees_bal_id number(9);
169: l_srs_ercontr_type_id pay_element_types_f.element_type_id%type;
170: l_srs_ercontr_obj_ver_number pay_element_types_f.object_version_number%type;
171: l_srs_ercontr_rep_name pay_element_types_f.reporting_name%type;
172: l_srs_ercontr_desc_name pay_element_types_f.description%type;
173: -- USERRA Changes
174: l_pt_userra_si_rule varchar2(2);

Line 171: l_srs_ercontr_rep_name pay_element_types_f.reporting_name%type;

167: l_inv_ded varchar2(22);
168: l_accr_fees_bal_id number(9);
169: l_srs_ercontr_type_id pay_element_types_f.element_type_id%type;
170: l_srs_ercontr_obj_ver_number pay_element_types_f.object_version_number%type;
171: l_srs_ercontr_rep_name pay_element_types_f.reporting_name%type;
172: l_srs_ercontr_desc_name pay_element_types_f.description%type;
173: -- USERRA Changes
174: l_pt_userra_si_rule varchar2(2);
175: l_pt_userra_rule varchar2(2);

Line 172: l_srs_ercontr_desc_name pay_element_types_f.description%type;

168: l_accr_fees_bal_id number(9);
169: l_srs_ercontr_type_id pay_element_types_f.element_type_id%type;
170: l_srs_ercontr_obj_ver_number pay_element_types_f.object_version_number%type;
171: l_srs_ercontr_rep_name pay_element_types_f.reporting_name%type;
172: l_srs_ercontr_desc_name pay_element_types_f.description%type;
173: -- USERRA Changes
174: l_pt_userra_si_rule varchar2(2);
175: l_pt_userra_rule varchar2(2);
176: l_pt_userra_er_rule varchar2(2);

Line 206: (sub_name pay_element_types_f.element_name%type);

202: l_relative_processing_priority number(15) ;
203:
204: l_ben_class_name ben_benefit_classifications.benefit_classification_name%type;
205: type r_temp_var is record
206: (sub_name pay_element_types_f.element_name%type);
207: type t_temp_var is table of r_temp_var
208: index by binary_integer;
209: l_temp_var t_temp_var;
210: --

Line 295: from pay_element_types_f pet

291: ,pet.element_type_id
292: ,piv.name
293: ,piv.input_value_id
294: ,piv.mandatory_flag
295: from pay_element_types_f pet
296: ,pay_input_values_f piv
297: where (pet.element_name like c_ele_prefix||'% Special Inputs'
298: or
299: pet.element_name like c_ele_prefix||'% SI' )

Line 320: l_iter_priority pay_element_types_f.iterative_priority%type;

316: and legislation_code = 'US';
317: --
318: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%type;
319: l_iter_formula_id ff_formulas_f.formula_id%type;
320: l_iter_priority pay_element_types_f.iterative_priority%type;
321: l_priority_inc number;
322: l_ele_template_priority number;
323: l_template_priority number;
324: --

Line 538: , PAY_ELEMENT_TYPES_F ET

534: from pay_balance_classifications bc
535: , PAY_BALANCE_FEEDS_F BF
536: , PAY_BALANCE_TYPES BT
537: , PAY_INPUT_VALUES_F IV
538: , PAY_ELEMENT_TYPES_F ET
539: , PAY_ELEMENT_CLASSIFICATIONS EC
540: , HR_LOOKUPS HL
541: , HR_LOOKUPS HL2
542: , FND_SESSIONS SES

Line 610: from pay_element_types_f

606: l_proc varchar2(200);
607: --
608: cursor c2 (c_object_name varchar2) is
609: select element_type_id
610: from pay_element_types_f
611: where element_name = c_object_name
612: and business_group_id = p_bg_id;
613: --
614: cursor c3 (c_object_name in varchar2) is

Line 921: (p_iter_element_type_id pay_element_types_f.element_type_id%type

917: -- =============================================================================
918: -- insert_iterative_rules:
919: -- =============================================================================
920: procedure insert_iterative_rules
921: (p_iter_element_type_id pay_element_types_f.element_type_id%type
922: ) is
923:
924: l_proc varchar2(160);
925:

Line 1885: update pay_element_types_f

1881: hr_utility.set_location(l_proc, 140);
1882: --
1883: -- Added for Garnishment rewrite --
1884: if p_ele_classification = l_inv_ded then
1885: update pay_element_types_f
1886: set element_information5 = l_cal_core_element_type_id,
1887: element_information8 = l_vol_ded_bal_id,
1888: element_information10 = l_pri_bal_id,
1889: element_information11 = l_accr_bal_id,

Line 1901: update pay_element_types_f

1897: --element_information20 = l_ver_core_element_type_id,
1898: where element_type_id = l_base_element_type_id
1899: and business_group_id = p_bg_id;
1900:
1901: update pay_element_types_f
1902: set element_information10 = l_fee_bal_id,
1903: element_information11 = l_accr_fees_bal_id
1904: where element_type_id = l_fees_core_element_type_id
1905: and business_group_id = p_bg_id;

Line 1911: from pay_element_types_f

1907: update pay_input_values_f
1908: set mandatory_flag = 'X'
1909: where name = 'Pay Value'
1910: and element_type_id in (select element_type_id
1911: from pay_element_types_f
1912: where element_name like p_ele_name ||'%');
1913: else
1914: update pay_element_types_f
1915: set element_information10 = l_pri_bal_id,

Line 1914: update pay_element_types_f

1910: and element_type_id in (select element_type_id
1911: from pay_element_types_f
1912: where element_name like p_ele_name ||'%');
1913: else
1914: update pay_element_types_f
1915: set element_information10 = l_pri_bal_id,
1916: element_information11 = l_accr_bal_id,
1917: element_information12 = l_arr_bal_id,
1918: element_information13 = l_not_taken_bal_id,

Line 1948: update pay_element_types_f

1944:
1945: hr_utility.set_location(l_proc, 170);
1946: --
1947: if p_after_tax_component = 'Y' then
1948: update pay_element_types_f
1949: set element_information10 = l_at_pri_bal_id,
1950: element_information11 = l_at_accr_bal_id,
1951: element_information12 = l_at_arr_bal_id,
1952: element_information13 = l_at_not_taken_bal_id,

Line 1970: update pay_element_types_f

1966:
1967: hr_utility.set_location(l_proc, 175);
1968: -- Update Roth element if Roth contribution is selected
1969: if p_roth_contribution = 'Y' then
1970: update pay_element_types_f
1971: set element_information10 = l_atr_pri_bal_id,
1972: element_information11 = l_atr_accr_bal_id,
1973: element_information12 = l_atr_arr_bal_id,
1974: element_information13 = l_atr_not_taken_bal_id,

Line 1989: update pay_element_types_f

1985: and balance_dimension_id = l_asg_gre_run_dim_id
1986: and business_group_id = p_bg_id;
1987: -- If ER component is selected then update the Roth ER match element
1988: if p_employer_match ='Y' then
1989: update pay_element_types_f
1990: set element_information1 = 'O',
1991: element_information10 = l_atr_er_bal_id,
1992: element_information_category = 'US_EMPLOYER LIABILITIES'
1993: where element_type_id = l_roth_er_ele_type_id

Line 2009: update pay_element_types_f

2005: hr_utility.set_location(l_proc, 180);
2006: -- Update the element_types_f table with the primary
2007: -- catchup balance id for the catch-up element
2008: if NVL(p_catchup_processing,'NONE') <> 'NONE' then
2009: update pay_element_types_f
2010: set element_information10 = l_cu_pri_bal_id,
2011: element_information11 = l_cu_accrued_bal_id,
2012: element_information12 = l_cu_arrears_bal_id,
2013: element_information13 = l_cu_nottaken_bal_id,

Line 2035: update pay_element_types_f

2031: hr_utility.set_location(l_proc, 190);
2032: -- Update the element_types_f table with the primary
2033: -- Buy Back balance id for the Buy-back element
2034: if NVL(p_ele_srs_buy_back,'N') <> 'N' then
2035: update pay_element_types_f
2036: set element_information10 = l_bb_pri_bal_id,
2037: element_information11 = l_bb_accrued_bal_id,
2038: element_information12 = l_bb_arrears_bal_id,
2039: element_information13 = l_bb_nottaken_bal_id,

Line 2062: update pay_element_types_f

2058: hr_utility.set_location(l_proc, 200);
2059: -- Update the element_types_f table with the primary
2060: -- ER Contribution balance id for the ER Contr element
2061: if nvl(p_ele_srs_plan_type,'N') <> 'N' then
2062: update pay_element_types_f
2063: set element_information10 = l_er_contr_pri_bal_id,
2064: element_information_category = 'US_EMPLOYER LIABILITIES'
2065: where element_type_id = l_er_contr_element_type_id
2066: and business_group_id = p_bg_id;

Line 2114: update pay_element_types_f

2110: --
2111: -- Update further info for the ER and AT ER elements
2112: --
2113: if p_employer_match = 'Y' then
2114: update pay_element_types_f
2115: set element_information1 = 'O',
2116: element_information10 = l_er_bal_id,
2117: element_information_category = 'US_EMPLOYER LIABILITIES'
2118: where element_type_id = l_er_element_type_id

Line 2122: update pay_element_types_f

2118: where element_type_id = l_er_element_type_id
2119: and business_group_id = p_bg_id;
2120: --
2121: if p_after_tax_component = 'Y' then
2122: update pay_element_types_f
2123: set element_information1 = 'O',
2124: element_information10 = l_at_er_bal_id,
2125: element_information_category = 'US_EMPLOYER LIABILITIES'
2126: where element_type_id = l_at_er_element_type_id