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 456: UPDATE pay_input_values_f

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

Line 1181: from pay_input_values_f

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

Line 1191: from pay_input_values_f

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

Line 1201: from pay_input_values_f

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

Line 1584: from pay_input_values_f

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

Line 1594: from pay_input_values_f

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

Line 1604: from pay_input_values_f

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

Line 1614: from pay_input_values_f

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

Line 3374: from pay_input_values_f pivf

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

Line 3521: pay_input_values_f i

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
3525: and e.business_group_id is null

Line 3574: pay_input_values_f i

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
3578: and e.business_group_id is null

Line 3661: pay_input_values_f i

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
3665: and e.business_group_id is null

Line 3714: pay_input_values_f i

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
3718: and e.business_group_id is null

Line 4678: from pay_input_values_f iv

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

Line 4698: UPDATE pay_input_values_f

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

Line 4744: from pay_input_values_f iv

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

Line 4778: from pay_input_values_f iv

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

Line 4823: from pay_input_values_f iv

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

Line 4964: FROM pay_input_values_f

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

Line 5011: FROM pay_input_values_f

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

Line 5352: FROM pay_input_values_f

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