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 1888: update pay_element_types_f

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

Line 1904: update pay_element_types_f

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

Line 1914: from pay_element_types_f

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

Line 1917: update pay_element_types_f

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

Line 1951: update pay_element_types_f

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

Line 1973: update pay_element_types_f

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

Line 1992: update pay_element_types_f

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

Line 2012: update pay_element_types_f

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

Line 2038: update pay_element_types_f

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

Line 2065: update pay_element_types_f

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

Line 2117: update pay_element_types_f

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

Line 2125: update pay_element_types_f

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