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_INPUT_VALUES_F

Line 237: from pay_input_values_f

233: -- Cursor to get Input Value ID's for the AT Element
234: --
235: cursor c_at_ivn(p_element_type_id in number) is
236: select input_value_id, name
237: from pay_input_values_f
238: where element_type_id = p_element_type_id
239: and name in ('Take Overlimit AT',
240: 'AT Processing Order')
241: and business_group_id = p_bg_id ;

Line 247: from pay_input_values_f

243: -- Cursor to get Input Value ID's for the Roth Element
244: --
245: cursor c_atr_ivn(p_element_type_id in number) is
246: select input_value_id, name
247: from pay_input_values_f
248: where element_type_id = p_element_type_id
249: and name in ('Take Overlimit Roth',
250: 'Roth Processing Order')
251: and business_group_id = p_bg_id ;

Line 296: ,pay_input_values_f piv

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' )
300: and piv.element_type_id = pet.element_type_id

Line 362: from pay_input_values_f

358: l_proc varchar2(200);
359:
360: cursor c_bal is
361: select input_value_id
362: from pay_input_values_f
363: where element_type_id = p_element_type_id
364: and name = 'Catchup Processing'
365: and business_group_id = p_bg_id ;
366:

Line 537: , PAY_INPUT_VALUES_F IV

533: ,et.element_type_id
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

Line 655: from pay_input_values_f

651: l_proc varchar2(200);
652:
653: cursor c_bal is
654: select input_value_id
655: from pay_input_values_f
656: where element_type_id = p_element_type_id
657: and name = 'Eligible Comp Option'
658: and business_group_id = p_bg_id ;
659:

Line 691: update pay_input_values_f

687: -- to US_ELIGIBLE_COMP_OPTIONS_EE
688: if nvl(p_employer_match ,'N') = 'N' then
689: --Added to get input value id for eligible Compensation option
690: l_eligiCmp_ipv_id := get_elgiComp_ipv (l_base_element_type_id);
691: update pay_input_values_f
692: set default_value = 'S_EE'
693: ,lookup_type = 'US_ELIGIBLE_COMP_OPTIONS_EE'
694: where input_value_id = l_eligicmp_ipv_id;
695: end if;

Line 782: update pay_input_values_f

778: --
779: -- Update the Default Value for Catchup Processing
780: -- to the one selected in the deductions form.
781: --
782: update pay_input_values_f
783: set default_value = substr(p_catchup_processing,1,1)
784: where input_value_id = l_cu_proc_inp_value_id;
785: end if;
786: --

Line 820: update pay_input_values_f

816: p_catchup_processing = 'NONE' then
817: for temp_rec in c_at_ivn(l_at_base_element_type_id)
818: loop
819: if temp_rec.name = 'Take Overlimit AT' then
820: update pay_input_values_f
821: set lookup_type = 'PQP_US_OVERLIMIT_AT1'
822: where input_value_id = temp_rec.input_value_id;
823: elsif temp_rec.name = 'AT Processing Order' then
824: update pay_input_values_f

Line 824: update pay_input_values_f

820: update pay_input_values_f
821: set lookup_type = 'PQP_US_OVERLIMIT_AT1'
822: where input_value_id = temp_rec.input_value_id;
823: elsif temp_rec.name = 'AT Processing Order' then
824: update pay_input_values_f
825: set lookup_type = 'PQP_US_AT_PROCESSING_ORDER1'
826: where input_value_id = temp_rec.input_value_id;
827: end if;
828: end loop;

Line 856: update pay_input_values_f

852: if nvl(p_employer_match ,'N') = 'N' and
853: p_ele_category in ('D') then
854: l_roth_eligiCmp_ipv_id := get_elgiComp_ipv (l_roth_ele_type_id);
855: if l_roth_eligiCmp_ipv_id is not null then
856: update pay_input_values_f
857: set default_value = 'S_EE'
858: ,lookup_type = 'US_ELIGIBLE_COMP_OPTIONS_EE'
859: where input_value_id = l_roth_eligiCmp_ipv_id;
860: end if;

Line 900: update pay_input_values_f

896: if p_catchup_processing = 'NONE' then
897: for temp_rec in c_atr_ivn(l_roth_er_ele_type_id)
898: loop
899: if temp_rec.name = 'Take Overlimit Roth' then
900: update pay_input_values_f
901: set lookup_type = 'PQP_US_OVERLIMIT_AT1'
902: where input_value_id = temp_rec.input_value_id;
903: elsif temp_rec.name = 'Roth Processing Order' then
904: update pay_input_values_f

Line 904: update pay_input_values_f

900: update pay_input_values_f
901: set lookup_type = 'PQP_US_OVERLIMIT_AT1'
902: where input_value_id = temp_rec.input_value_id;
903: elsif temp_rec.name = 'Roth Processing Order' then
904: update pay_input_values_f
905: set lookup_type = 'PQP_US_AT_PROCESSING_ORDER1'
906: where input_value_id = temp_rec.input_value_id;
907: end if;
908: end loop;

Line 1910: update pay_input_values_f

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;
1909:
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

Line 2184: update pay_input_values_f piv

2180: -- created under this pre-tax deduction plan.
2181: for i in csr_ele(c_effective_date => p_ele_eff_start_date
2182: ,c_ele_prefix => p_ele_name )
2183: loop
2184: update pay_input_values_f piv
2185: set piv.mandatory_flag = 'X'
2186: where piv.input_value_id = i.input_value_id
2187: and piv.element_type_id = i.element_type_id
2188: and piv.business_group_id = p_bg_id;