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_CORE_FF_UDFS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1354: FROM pay_element_entry_values_f EEV

1350: p_range_end date) IS
1351: SELECT EEV.screen_entry_value,
1352: EEV.effective_start_date,
1353: EEV.effective_end_date
1354: FROM pay_element_entry_values_f EEV
1355: WHERE EEV.element_entry_id = p_element_entry_id
1356: AND EEV.input_value_id = p_inpval_id
1357: AND EEV.effective_start_date > p_range_start
1358: AND EEV.effective_end_date <= p_range_end

Line 1397: FROM pay_element_entry_values_f EEV

1393: EEV.effective_end_date
1394: INTO v_earnings_entry,
1395: v_entry_start,
1396: v_entry_end
1397: FROM pay_element_entry_values_f EEV
1398: WHERE EEV.element_entry_id = p_element_entry_id
1399: AND EEV.input_value_id = p_inpval_id
1400: AND EEV.effective_start_date <= p_range_start_date
1401: AND EEV.effective_end_date >= p_range_start_date

Line 1529: FROM pay_element_entry_values_f EEV

1525: LEAST(EEV.effective_end_date, p_range_end_date)
1526: INTO v_earnings_entry,
1527: v_entry_start,
1528: v_entry_end
1529: FROM pay_element_entry_values_f EEV
1530: WHERE EEV.element_entry_id = p_element_entry_id
1531: AND EEV.input_value_id = p_inpval_id
1532: AND EEV.effective_start_date > p_range_start_date
1533: AND EEV.effective_start_date <= p_range_end_date

Line 1616: pay_element_entry_values_f pev

1612: v_eff_date DATE) IS
1613: select fnd_number.canonical_to_number(pev.screen_entry_value)
1614: from per_absence_attendance_types abt,
1615: pay_element_entries_f pee,
1616: pay_element_entry_values_f pev
1617: where pev.input_value_id = abt.input_value_id
1618: and abt.absence_category = 'V'
1619: and v_eff_date between pev.effective_start_date
1620: and pev.effective_end_date

Line 1682: pay_element_entry_values_f pev

1678: v_eff_date DATE) IS
1679: select fnd_number.canonical_to_number(pev.screen_entry_value)
1680: from per_absence_attendance_types abt,
1681: pay_element_entries_f pee,
1682: pay_element_entry_values_f pev
1683: where pev.input_value_id = abt.input_value_id
1684: and abt.absence_category = 'S'
1685: and v_eff_date between pev.effective_start_date
1686: and pev.effective_end_date

Line 2163: FROM pay_element_entry_values_f EEV

2159: select 1 INTO l_eev_info_changes
2160: from dual
2161: where exists (
2162: SELECT 1
2163: FROM pay_element_entry_values_f EEV
2164: WHERE EEV.element_entry_id = p_ele_entry_id
2165: AND EEV.input_value_id+0 = v_inpval_id
2166: AND ( ( EEV.effective_start_date <= p_period_start
2167: AND EEV.effective_end_date >= p_period_start

Line 2231: FROM pay_element_entry_values_f EEV

2227: select 1 INTO l_eev_info_changes
2228: from dual
2229: where exists (
2230: SELECT 1
2231: FROM pay_element_entry_values_f EEV
2232: WHERE EEV.element_entry_id = p_ele_entry_id
2233: AND EEV.input_value_id+0 = v_inpval_id
2234: AND ( ( EEV.effective_start_date <= p_period_start
2235: AND EEV.effective_end_date >= p_period_start

Line 2278: FROM pay_element_entry_values_f EEV

2274: select 1 INTO l_eev_info_changes
2275: from dual
2276: where exists (
2277: SELECT 1
2278: FROM pay_element_entry_values_f EEV
2279: WHERE EEV.element_entry_id = p_ele_entry_id
2280: AND EEV.input_value_id+0 = v_inpval_id
2281: AND EEV.effective_start_date <= p_period_start
2282: AND EEV.effective_end_date >= p_period_start

Line 2623: FROM pay_element_entry_values_f EEV

2619: hr_utility.set_location('calculate_period_earnings', 128);
2620:
2621: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2622: INTO v_earnings_entry
2623: FROM pay_element_entry_values_f EEV
2624: WHERE EEV.element_entry_id = p_ele_entry_id
2625: AND EEV.input_value_id = v_inpval_id
2626: AND p_period_start between EEV.effective_start_date
2627: AND EEV.effective_end_date;

Line 2693: FROM pay_element_entry_values_f EEV

2689: hr_utility.set_location('calculate_period_earnings', 130);
2690:
2691: SELECT COUNT(EEV.element_entry_value_id)
2692: INTO l_eev_info_changes
2693: FROM pay_element_entry_values_f EEV
2694: WHERE EEV.element_entry_id = p_ele_entry_id
2695: AND EEV.input_value_id = v_inpval_id
2696: AND EEV.effective_start_date <= v_range_start
2697: AND EEV.effective_end_date >= v_range_start

Line 2708: FROM pay_element_entry_values_f EEV

2704: hr_utility.set_location('calculate_period_earnings', 132);
2705:
2706: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2707: INTO v_earnings_entry
2708: FROM pay_element_entry_values_f EEV
2709: WHERE EEV.element_entry_id = p_ele_entry_id
2710: AND EEV.input_value_id = v_inpval_id
2711: AND v_range_end BETWEEN EEV.effective_start_date
2712: AND EEV.effective_end_date;

Line 2801: FROM pay_element_entry_values_f EEV

2797: hr_utility.set_location('calculate_period_earnings', 145);
2798:
2799: SELECT COUNT(EEV.element_entry_value_id)
2800: INTO l_eev_info_changes
2801: FROM pay_element_entry_values_f EEV
2802: WHERE EEV.element_entry_id = p_ele_entry_id
2803: AND EEV.input_value_id = v_inpval_id
2804: AND EEV.effective_start_date <= v_range_start
2805: AND EEV.effective_end_date >= v_range_start

Line 2815: FROM pay_element_entry_values_f EEV

2811:
2812: hr_utility.trace('BOTH ASG - EEV false');
2813: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2814: INTO v_earnings_entry
2815: FROM pay_element_entry_values_f EEV
2816: WHERE EEV.element_entry_id = p_ele_entry_id
2817: AND EEV.input_value_id = v_inpval_id
2818: AND v_range_end BETWEEN EEV.effective_start_date
2819: AND EEV.effective_end_date;

Line 2911: FROM pay_element_entry_values_f EEV

2907: hr_utility.trace('SELECT EEVMPE');
2908:
2909: SELECT COUNT(EEV.element_entry_value_id)
2910: INTO l_eev_info_changes
2911: FROM pay_element_entry_values_f EEV
2912: WHERE EEV.element_entry_id = p_ele_entry_id
2913: AND EEV.input_value_id = v_inpval_id
2914: AND EEV.effective_start_date <= v_range_start
2915: AND EEV.effective_end_date >= v_range_start

Line 2925: FROM pay_element_entry_values_f EEV

2921: hr_utility.set_location('calculate_period_earnings', 165);
2922:
2923: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2924: INTO v_earnings_entry
2925: FROM pay_element_entry_values_f EEV
2926: WHERE EEV.element_entry_id = p_ele_entry_id
2927: AND EEV.input_value_id = v_inpval_id
2928: AND v_range_end BETWEEN EEV.effective_start_date
2929: AND EEV.effective_end_date;

Line 3089: , pay_element_entry_values_f EEV

3085: l_assignment_id number,
3086: l_input_value_id number) IS
3087: select fnd_number.canonical_to_number (EEV.screen_entry_value)
3088: from pay_element_entries_f EE
3089: , pay_element_entry_values_f EEV
3090: where EEV.input_value_id = l_input_value_id
3091: and l_date_earned BETWEEN EEV.effective_start_date
3092: AND EEV.effective_end_date
3093: and EE.assignment_id = l_assignment_id

Line 4148: pay_element_entry_values_f pev

4144: v_eff_date DATE) IS
4145: select fnd_number.canonical_to_number(pev.screen_entry_value)
4146: from per_absence_attendance_types abt,
4147: pay_element_entries_f pee,
4148: pay_element_entry_values_f pev
4149: where pev.input_value_id = abt.input_value_id
4150: and abt.absence_category = 'S'
4151: and v_eff_date between pev.effective_start_date
4152: and pev.effective_end_date

Line 4170: ,pay_element_entry_values_f peev

4166: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4167: from per_absence_attendance_types abt
4168: ,per_absence_attendances abs
4169: ,pay_element_entries_f pee
4170: ,pay_element_entry_values_f peev
4171: where abt.input_value_id = peev.input_value_id
4172: and abt.absence_category = 'S'
4173: and abt.absence_attendance_type_id = abs.absence_attendance_type_id
4174: and peev.element_entry_id = pee.element_entry_id

Line 4281: pay_element_entry_values_f pev

4277: v_eff_date DATE) IS
4278: select fnd_number.canonical_to_number(pev.screen_entry_value)
4279: from per_absence_attendance_types abt,
4280: pay_element_entries_f pee,
4281: pay_element_entry_values_f pev
4282: where pev.input_value_id = abt.input_value_id
4283: and abt.absence_category = 'V'
4284: and v_eff_date between pev.effective_start_date
4285: and pev.effective_end_date

Line 4303: ,pay_element_entry_values_f peev

4299: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4300: from per_absence_attendance_types abt
4301: ,per_absence_attendances abs
4302: ,pay_element_entries_f pee
4303: ,pay_element_entry_values_f peev
4304: where abt.input_value_id = peev.input_value_id
4305: and abt.absence_category = 'V'
4306: and abt.absence_attendance_type_id = abs.absence_attendance_type_id
4307: and peev.element_entry_id = pee.element_entry_id