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_INPUT_VALUES_F

Line 458: UPDATE pay_input_values_f

454: -- Now, make Pay Value non-enterable by setting MANDATORY_FLAG = 'X':
455: --
456: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
457: --
458: UPDATE pay_input_values_f
459: SET mandatory_flag = 'X'
460: WHERE element_type_id = v_eletype_id
461: AND name = v_pay_value_name;
462: --

Line 1183: from pay_input_values_f

1179: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1180: hr_utility.set_location('pyusuiet',200);
1181: select input_value_id
1182: into v_hbyr_ele_inpval_id
1183: from pay_input_values_f
1184: where element_type_id = v_hbyr_ele_type_id
1185: and name = 'Element Type Id'
1186: and sysdate between effective_start_date
1187: and effective_end_date;

Line 1193: from pay_input_values_f

1189: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1190: hr_utility.set_location('pyusuiet',205);
1191: select input_value_id
1192: into v_hbyr_rate_inpval_id
1193: from pay_input_values_f
1194: where element_type_id = v_hbyr_ele_type_id
1195: and name = 'Rate'
1196: and sysdate between effective_start_date
1197: and effective_end_date;

Line 1203: from pay_input_values_f

1199: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1200: hr_utility.set_location('pyusuiet',210);
1201: select input_value_id
1202: into v_hbyr_hours_inpval_id
1203: from pay_input_values_f
1204: where element_type_id = v_hbyr_ele_type_id
1205: and name = 'Hours'
1206: and sysdate between effective_start_date
1207: and effective_end_date;

Line 1586: from pay_input_values_f

1582: hr_utility.trace('Get Hours By Rate Element Inpval Id');
1583: hr_utility.set_location('pyusuiet',325);
1584: select input_value_id
1585: into v_hbyr_ele_inpval_id
1586: from pay_input_values_f
1587: where element_type_id = v_hbyr_ele_type_id
1588: and name = 'Element Type Id'
1589: and sysdate between effective_start_date
1590: and effective_end_date;

Line 1596: from pay_input_values_f

1592: hr_utility.trace('Get Hours By Rate Rate Inpval Id');
1593: hr_utility.set_location('pyusuiet',330);
1594: select input_value_id
1595: into v_hbyr_rate_inpval_id
1596: from pay_input_values_f
1597: where element_type_id = v_hbyr_ele_type_id
1598: and name = 'Rate'
1599: and sysdate between effective_start_date
1600: and effective_end_date;

Line 1606: from pay_input_values_f

1602: hr_utility.trace('Get Hours By Rate Hours Inpval Id');
1603: hr_utility.set_location('pyusuiet',335);
1604: select input_value_id
1605: into v_hbyr_hours_inpval_id
1606: from pay_input_values_f
1607: where element_type_id = v_hbyr_ele_type_id
1608: and name = 'Hours'
1609: and sysdate between effective_start_date
1610: and effective_end_date;

Line 1616: from pay_input_values_f

1612: hr_utility.trace('Get Hours By Rate Multiple Inpval Id');
1613: hr_utility.set_location('pyusuiet',340);
1614: select input_value_id
1615: into v_hbyr_mult_inpval_id
1616: from pay_input_values_f
1617: where element_type_id = v_hbyr_ele_type_id
1618: and name = 'Multiple'
1619: and sysdate between effective_start_date
1620: and effective_end_date;

Line 3376: from pay_input_values_f pivf

3372:
3373: hr_utility.set_location('pyusuiet',750);
3374: select pivf.input_value_id
3375: into g_shadow_info_payval_id
3376: from pay_input_values_f pivf
3377: where pivf.element_type_id = p_shadow_ele_type_id
3378: and pivf.name = 'Pay Value';
3379:
3380: hr_utility.set_location('pyusuiet',755);

Line 3523: pay_input_values_f i

3519:
3520: select i.input_value_id
3521: into l_pv_id
3522: from pay_element_types_f e,
3523: pay_input_values_f i
3524: where e.element_name = 'Regular Salary'
3525: and p_eff_start_date between e.effective_start_date
3526: and e.effective_end_date
3527: and e.business_group_id is null

Line 3576: pay_input_values_f i

3572:
3573: select i.input_value_id
3574: into l_pv_id
3575: from pay_element_types_f e,
3576: pay_input_values_f i
3577: where e.element_name = 'Regular Wages'
3578: and p_eff_start_date between e.effective_start_date
3579: and e.effective_end_date
3580: and e.business_group_id is null

Line 3663: pay_input_values_f i

3659:
3660: select i.input_value_id
3661: into l_pv_id
3662: from pay_element_types_f e,
3663: pay_input_values_f i
3664: where e.element_name = 'Regular Salary'
3665: and p_eff_start_date between e.effective_start_date
3666: and e.effective_end_date
3667: and e.business_group_id is null

Line 3716: pay_input_values_f i

3712:
3713: select i.input_value_id
3714: into l_pv_id
3715: from pay_element_types_f e,
3716: pay_input_values_f i
3717: where e.element_name = 'Regular Wages'
3718: and p_eff_start_date between e.effective_start_date
3719: and e.effective_end_date
3720: and e.business_group_id is null

Line 4680: from pay_input_values_f iv

4676:
4677: hr_utility.set_location('pyusuiet',1065);
4678: select iv.input_value_id
4679: into v_payval_id
4680: from pay_input_values_f iv
4681: where iv.element_type_id = v_ele_type_id
4682: and iv.business_group_id = p_bg_id
4683: and iv.name = v_payval_name;
4684: --

Line 4700: UPDATE pay_input_values_f

4696: AND legislation_code = 'US'
4697: AND formula_name = 'PAYVALUE_VALIDATION';
4698:
4699: hr_utility.set_location('pyusuiet',1067);
4700: UPDATE pay_input_values_f
4701: SET formula_id = v_payval_formula_id,
4702: warning_or_error = 'E'
4703: WHERE input_value_id = v_payval_id;
4704: */

Line 4746: from pay_input_values_f iv

4742: hr_utility.set_location('pyusuiet',1070);
4743: /*
4744: select iv.input_value_id
4745: into v_negearn_inpval_id
4746: from pay_input_values_f iv
4747: where iv.element_type_id = v_shadow_ele_type_id
4748: and iv.name = 'Neg Earnings';
4749: */
4750: --

Line 4780: from pay_input_values_f iv

4776:
4777: /*
4778: select iv.input_value_id
4779: into v_addl_inpval_id
4780: from pay_input_values_f iv
4781: where iv.element_type_id = v_shadow_ele_type_id
4782: and iv.name = 'Addl Amt';
4783: */
4784: --

Line 4825: from pay_input_values_f iv

4821: hr_utility.set_location('pyusuiet',1086);
4822: /*
4823: select iv.input_value_id
4824: into g_repl_inpval_id
4825: from pay_input_values_f iv
4826: where iv.element_type_id = v_shadow_ele_type_id
4827: and iv.name = 'Replacement Amt';
4828: */
4829: --

Line 4966: FROM pay_input_values_f

4962:
4963: hr_utility.set_location('pyusuiet',1135);
4964: SELECT input_value_id
4965: INTO v_hrs_inpval_id
4966: FROM pay_input_values_f
4967: WHERE element_type_id = v_ele_type_id
4968: AND business_group_id = p_bg_id
4969: AND name = 'Hours';
4970:

Line 5013: FROM pay_input_values_f

5009:
5010: hr_utility.set_location('pyusuiet',1155);
5011: SELECT input_value_id
5012: INTO v_hrs_inpval_id
5013: FROM pay_input_values_f
5014: WHERE element_type_id = v_ele_type_id
5015: AND business_group_id = p_bg_id
5016: AND name = 'Hours';
5017:

Line 5354: FROM pay_input_values_f

5350: v_baltype_count NUMBER(3);
5351:
5352: CURSOR get_inpvals IS
5353: SELECT input_value_id
5354: FROM pay_input_values_f
5355: WHERE element_type_id = p_ele_type_id;
5356:
5357: CURSOR get_formulae IS
5358: SELECT formula_id