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

Line 660: UPDATE pay_element_types_f

656: --
657: IF UPPER(p_ele_class_name) = 'EARNINGS' THEN
658: v_ele_info_cat := 'US_EARNINGS';
659: hr_utility.set_location('pyusuiet',45);
660: UPDATE pay_element_types_f
661: SET element_information_category = v_ele_info_cat,
662: element_information1 = p_ele_cat,
663: element_information8 = p_include_in_ot,
664: element_information11 = p_flsa_hrs,

Line 671: UPDATE pay_element_types_f

667: WHERE element_type_id = p_ele_id
668: AND business_group_id = p_bg_id;
669: --
670: hr_utility.set_location('pyusuiet',50);
671: UPDATE pay_element_types_f
672: SET element_information_category = v_ele_info_cat,
673: element_information1 = p_ele_cat,
674: element_information8 = p_include_in_ot
675: WHERE element_type_id = p_shadow_ele_id

Line 682: UPDATE pay_element_types_f

678:
679: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
680:
681: hr_utility.set_location('pyusuiet',55);
682: UPDATE pay_element_types_f
683: SET element_information_category = v_ele_info_cat,
684: element_information1 = p_ele_cat,
685: element_information8 = p_include_in_ot
686: WHERE element_type_id = p_inputs_ele_id

Line 696: UPDATE pay_element_types_f

692: ELSIF UPPER(p_ele_class_name) = 'SUPPLEMENTAL EARNINGS' THEN
693:
694: v_ele_info_cat := 'US_SUPPLEMENTAL EARNINGS';
695: hr_utility.set_location('pyusuiet',60);
696: UPDATE pay_element_types_f
697: SET element_information_category = v_ele_info_cat,
698: element_information1 = p_ele_cat,
699: element_information8 = p_include_in_ot,
700: element_information11 = p_flsa_hrs,

Line 707: UPDATE pay_element_types_f

703: WHERE element_type_id = p_ele_id
704: AND business_group_id = p_bg_id;
705: --
706: hr_utility.set_location('pyusuiet',65);
707: UPDATE pay_element_types_f
708: SET element_information_category = v_ele_info_cat,
709: element_information1 = p_ele_cat,
710: element_information8 = p_include_in_ot
711: WHERE element_type_id = p_shadow_ele_id

Line 717: UPDATE pay_element_types_f

713: --
714: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
715:
716: hr_utility.set_location('pyusuiet',70);
717: UPDATE pay_element_types_f
718: SET element_information_category = v_ele_info_cat,
719: element_information1 = p_ele_cat,
720: element_information8 = p_include_in_ot
721: WHERE element_type_id = p_inputs_ele_id

Line 730: UPDATE pay_element_types_f

726: ELSIF UPPER(p_ele_class_name) = 'IMPUTED EARNINGS' THEN
727:
728: v_ele_info_cat := 'US_IMPUTED EARNINGS';
729: hr_utility.set_location('pyusuiet',75);
730: UPDATE pay_element_types_f
731: SET element_information_category = v_ele_info_cat,
732: element_information1 = p_ele_cat,
733: element_information9 = v_mix_category,
734: element_information12 = p_hrs_baltype_id

Line 739: UPDATE pay_element_types_f

735: WHERE element_type_id = p_ele_id
736: AND business_group_id = p_bg_id;
737: --
738: hr_utility.set_location('pyusuiet',80);
739: UPDATE pay_element_types_f
740: SET element_information_category = v_ele_info_cat,
741: element_information1 = p_ele_cat
742: WHERE element_type_id = p_shadow_ele_id
743: AND business_group_id = p_bg_id;

Line 749: UPDATE pay_element_types_f

745:
746: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
747:
748: hr_utility.set_location('pyusuiet',85);
749: UPDATE pay_element_types_f
750: SET element_information_category = v_ele_info_cat,
751: element_information1 = p_ele_cat
752: WHERE element_type_id = p_inputs_ele_id
753: AND business_group_id = p_bg_id;

Line 762: UPDATE pay_element_types_f

758: ELSIF UPPER(p_ele_class_name) = 'NON-PAYROLL PAYMENTS' THEN
759:
760: v_ele_info_cat := 'US_NON-PAYROLL PAYMENTS';
761: hr_utility.set_location('pyusuiet',90);
762: UPDATE pay_element_types_f
763: SET element_information_category = v_ele_info_cat,
764: element_information1 = p_ele_cat,
765: element_information9 = v_mix_category
766: WHERE element_type_id = p_ele_id

Line 770: UPDATE pay_element_types_f

766: WHERE element_type_id = p_ele_id
767: AND business_group_id = p_bg_id;
768: --
769: hr_utility.set_location('pyusuiet',95);
770: UPDATE pay_element_types_f
771: SET element_information_category = v_ele_info_cat,
772: element_information1 = p_ele_cat
773: WHERE element_type_id = p_shadow_ele_id
774: AND business_group_id = p_bg_id;

Line 779: UPDATE pay_element_types_f

775: --
776: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
777:
778: hr_utility.set_location('pyusuiet',100);
779: UPDATE pay_element_types_f
780: SET element_information_category = v_ele_info_cat,
781: element_information1 = p_ele_cat
782: WHERE element_type_id = p_inputs_ele_id
783: AND business_group_id = p_bg_id;

Line 794: UPDATE pay_element_types_f

790: --
791: ELSE
792: -- Ele is a grossup ele, Information classification, just set mix flag.
793: hr_utility.set_location('pyusuiet',105);
794: UPDATE pay_element_types_f
795: SET element_information9 = v_mix_category
796: WHERE element_type_id = p_ele_id
797: AND business_group_id = p_bg_id;
798: --

Line 1171: from pay_element_types_f

1167: hr_utility.trace('Get Hours By Rate Element Id');
1168: hr_utility.set_location('pyusuiet',195);
1169: select element_type_id
1170: into v_hbyr_ele_type_id
1171: from pay_element_types_f
1172: where element_name = 'Hours by Rate'
1173: and legislation_code = g_template_leg_code
1174: and sysdate between effective_start_date
1175: and effective_end_date;

Line 1574: from pay_element_types_f

1570: hr_utility.trace('Get Hours By Rate Element Id');
1571: hr_utility.set_location('pyusuiet',320);
1572: select element_type_id
1573: into v_hbyr_ele_type_id
1574: from pay_element_types_f
1575: where element_name = 'Hours by Rate'
1576: and legislation_code = g_template_leg_code
1577: and sysdate between effective_start_date
1578: and effective_end_date;

Line 3520: from pay_element_types_f e,

3516: l_pv_name := hr_input_values.get_pay_value_name(g_template_leg_code);
3517:
3518: select i.input_value_id
3519: into l_pv_id
3520: from pay_element_types_f e,
3521: pay_input_values_f i
3522: where e.element_name = 'Regular Salary'
3523: and p_eff_start_date between e.effective_start_date
3524: and e.effective_end_date

Line 3573: from pay_element_types_f e,

3569:
3570:
3571: select i.input_value_id
3572: into l_pv_id
3573: from pay_element_types_f e,
3574: pay_input_values_f i
3575: where e.element_name = 'Regular Wages'
3576: and p_eff_start_date between e.effective_start_date
3577: and e.effective_end_date

Line 3660: from pay_element_types_f e,

3656: l_pv_name := hr_input_values.get_pay_value_name(g_template_leg_code);
3657:
3658: select i.input_value_id
3659: into l_pv_id
3660: from pay_element_types_f e,
3661: pay_input_values_f i
3662: where e.element_name = 'Regular Salary'
3663: and p_eff_start_date between e.effective_start_date
3664: and e.effective_end_date

Line 3713: from pay_element_types_f e,

3709:
3710:
3711: select i.input_value_id
3712: into l_pv_id
3713: from pay_element_types_f e,
3714: pay_input_values_f i
3715: where e.element_name = 'Regular Wages'
3716: and p_eff_start_date between e.effective_start_date
3717: and e.effective_end_date

Line 4296: from pay_element_types_f

4292: -- Need to find PRIMARY_CLASSIFICATION_ID of element type.
4293: hr_utility.set_location('pyusuiet',1020);
4294: select distinct(classification_id)
4295: into v_primary_class_id
4296: from pay_element_types_f
4297: where element_type_id = v_ele_type_id;
4298: --
4299: hr_utility.set_location('pyusuiet',1025);
4300: SELECT default_low_priority,

Line 4665: UPDATE pay_element_types_f

4661: -- Also, update element type DDF with associated balances for this
4662: -- earning. Current associated balances for Regular/Supplemental/Imputed
4663: -- Earnings: "Primary Balance" - hold in ELEMENT_INFORMATION10
4664: -- Update Termination Rule for the base element.
4665: UPDATE pay_element_types_f
4666: SET element_information10 = v_bal_type_id,
4667: post_termination_rule = p_termination_rule
4668: WHERE element_type_id = v_ele_type_id
4669: AND business_group_id = p_bg_id;

Line 5219: update pay_element_types_f

5215:
5216: -- Create feeds to all bals fed by RegSal and Wages pay values.
5217: create_reduce_regpay_feeds (p_eff_start_date => g_eff_start_date);
5218:
5219: update pay_element_types_f
5220: set element_information13 = 'Y'
5221: where element_type_id = v_ele_type_id;
5222:
5223: end if;

Line 5442: FROM pay_element_types_f

5438: SELECT element_type_id,
5439: processing_priority
5440: INTO v_shadow_eletype_id,
5441: v_shadow_ele_priority
5442: FROM pay_element_types_f
5443: WHERE element_name = SUBSTR(p_ele_name || ' Special Features', 1, 80)
5444: AND business_group_id = p_business_group_id;
5445:
5446: exception when NO_DATA_FOUND then

Line 5458: FROM pay_element_types_f

5454: SELECT element_type_id,
5455: processing_priority
5456: INTO v_inputs_eletype_id,
5457: v_inputs_ele_priority
5458: FROM pay_element_types_f
5459: WHERE element_name = SUBSTR(p_ele_name || ' Special Inputs', 1, 80)
5460: AND business_group_id = p_business_group_id;
5461:
5462: exception when NO_DATA_FOUND then

Line 5486: delete from PAY_ELEMENT_TYPES_F

5482: p_startup_mode => v_startup_mode);
5483:
5484: -- Delete element type record:
5485: hr_utility.set_location('pyusuiet',1257);
5486: delete from PAY_ELEMENT_TYPES_F
5487: where element_type_id = p_ele_type_id;
5488:
5489: --
5490: -- DELETE ASSOCIATED BALANCES AND OTHER BALANCES CREATED FOR THIS DEDN.

Line 5644: delete from PAY_ELEMENT_TYPES_F

5640: p_val_end_date => v_del_val_end,
5641: p_startup_mode => v_startup_mode);
5642:
5643: hr_utility.set_location('pyusuiet',1295);
5644: delete from PAY_ELEMENT_TYPES_F
5645: where element_type_id = v_shadow_eletype_id;
5646:
5647: --
5648: -- Delete Special Inputs element...

Line 5669: delete from PAY_ELEMENT_TYPES_F

5665: p_val_end_date => v_del_val_end,
5666: p_startup_mode => v_startup_mode);
5667:
5668: hr_utility.set_location('pyusuiet',1310);
5669: delete from PAY_ELEMENT_TYPES_F
5670: where element_type_id = v_inputs_eletype_id;
5671: --
5672: EXCEPTION
5673: WHEN NO_DATA_FOUND THEN NULL;