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 975: FROM pay_element_entry_values_f EEV

971: p_range_end date) IS
972: SELECT EEV.screen_entry_value,
973: EEV.effective_start_date,
974: EEV.effective_end_date
975: FROM pay_element_entry_values_f EEV
976: WHERE EEV.element_entry_id = p_element_entry_id
977: AND EEV.input_value_id = p_inpval_id
978: AND EEV.effective_start_date > p_range_start
979: AND EEV.effective_end_date <= p_range_end

Line 1018: FROM pay_element_entry_values_f EEV

1014: EEV.effective_end_date
1015: INTO v_earnings_entry,
1016: v_entry_start,
1017: v_entry_end
1018: FROM pay_element_entry_values_f EEV
1019: WHERE EEV.element_entry_id = p_element_entry_id
1020: AND EEV.input_value_id = p_inpval_id
1021: AND EEV.effective_start_date <= p_range_start_date
1022: AND EEV.effective_end_date >= p_range_start_date

Line 1150: FROM pay_element_entry_values_f EEV

1146: LEAST(EEV.effective_end_date, p_range_end_date)
1147: INTO v_earnings_entry,
1148: v_entry_start,
1149: v_entry_end
1150: FROM pay_element_entry_values_f EEV
1151: WHERE EEV.element_entry_id = p_element_entry_id
1152: AND EEV.input_value_id = p_inpval_id
1153: AND EEV.effective_start_date > p_range_start_date
1154: AND EEV.effective_start_date <= p_range_end_date

Line 1237: pay_element_entry_values_f pev

1233: v_eff_date DATE) IS
1234: select fnd_number.canonical_to_number(pev.screen_entry_value)
1235: from per_absence_attendance_types abt,
1236: pay_element_entries_f pee,
1237: pay_element_entry_values_f pev
1238: where pev.input_value_id = abt.input_value_id
1239: and abt.absence_category = 'V'
1240: and v_eff_date between pev.effective_start_date
1241: and pev.effective_end_date

Line 1303: pay_element_entry_values_f pev

1299: v_eff_date DATE) IS
1300: select fnd_number.canonical_to_number(pev.screen_entry_value)
1301: from per_absence_attendance_types abt,
1302: pay_element_entries_f pee,
1303: pay_element_entry_values_f pev
1304: where pev.input_value_id = abt.input_value_id
1305: and abt.absence_category = 'S'
1306: and v_eff_date between pev.effective_start_date
1307: and pev.effective_end_date

Line 1784: FROM pay_element_entry_values_f EEV

1780: select 1 INTO l_eev_info_changes
1781: from dual
1782: where exists (
1783: SELECT 1
1784: FROM pay_element_entry_values_f EEV
1785: WHERE EEV.element_entry_id = p_ele_entry_id
1786: AND EEV.input_value_id+0 = v_inpval_id
1787: AND ( ( EEV.effective_start_date <= p_period_start
1788: AND EEV.effective_end_date >= p_period_start

Line 1852: FROM pay_element_entry_values_f EEV

1848: select 1 INTO l_eev_info_changes
1849: from dual
1850: where exists (
1851: SELECT 1
1852: FROM pay_element_entry_values_f EEV
1853: WHERE EEV.element_entry_id = p_ele_entry_id
1854: AND EEV.input_value_id+0 = v_inpval_id
1855: AND ( ( EEV.effective_start_date <= p_period_start
1856: AND EEV.effective_end_date >= p_period_start

Line 1899: FROM pay_element_entry_values_f EEV

1895: select 1 INTO l_eev_info_changes
1896: from dual
1897: where exists (
1898: SELECT 1
1899: FROM pay_element_entry_values_f EEV
1900: WHERE EEV.element_entry_id = p_ele_entry_id
1901: AND EEV.input_value_id+0 = v_inpval_id
1902: AND EEV.effective_start_date <= p_period_start
1903: AND EEV.effective_end_date >= p_period_start

Line 2214: FROM pay_element_entry_values_f EEV

2210: hr_utility.set_location('calculate_period_earnings', 128);
2211:
2212: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2213: INTO v_earnings_entry
2214: FROM pay_element_entry_values_f EEV
2215: WHERE EEV.element_entry_id = p_ele_entry_id
2216: AND EEV.input_value_id = v_inpval_id
2217: AND p_period_start between EEV.effective_start_date
2218: AND EEV.effective_end_date;

Line 2284: FROM pay_element_entry_values_f EEV

2280: hr_utility.set_location('calculate_period_earnings', 130);
2281:
2282: SELECT COUNT(EEV.element_entry_value_id)
2283: INTO l_eev_info_changes
2284: FROM pay_element_entry_values_f EEV
2285: WHERE EEV.element_entry_id = p_ele_entry_id
2286: AND EEV.input_value_id = v_inpval_id
2287: AND EEV.effective_start_date <= v_range_start
2288: AND EEV.effective_end_date >= v_range_start

Line 2299: FROM pay_element_entry_values_f EEV

2295: hr_utility.set_location('calculate_period_earnings', 132);
2296:
2297: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2298: INTO v_earnings_entry
2299: FROM pay_element_entry_values_f EEV
2300: WHERE EEV.element_entry_id = p_ele_entry_id
2301: AND EEV.input_value_id = v_inpval_id
2302: AND v_range_end BETWEEN EEV.effective_start_date
2303: AND EEV.effective_end_date;

Line 2392: FROM pay_element_entry_values_f EEV

2388: hr_utility.set_location('calculate_period_earnings', 145);
2389:
2390: SELECT COUNT(EEV.element_entry_value_id)
2391: INTO l_eev_info_changes
2392: FROM pay_element_entry_values_f EEV
2393: WHERE EEV.element_entry_id = p_ele_entry_id
2394: AND EEV.input_value_id = v_inpval_id
2395: AND EEV.effective_start_date <= v_range_start
2396: AND EEV.effective_end_date >= v_range_start

Line 2406: FROM pay_element_entry_values_f EEV

2402:
2403: hr_utility.trace('BOTH ASG - EEV false');
2404: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2405: INTO v_earnings_entry
2406: FROM pay_element_entry_values_f EEV
2407: WHERE EEV.element_entry_id = p_ele_entry_id
2408: AND EEV.input_value_id = v_inpval_id
2409: AND v_range_end BETWEEN EEV.effective_start_date
2410: AND EEV.effective_end_date;

Line 2502: FROM pay_element_entry_values_f EEV

2498: hr_utility.trace('SELECT EEVMPE');
2499:
2500: SELECT COUNT(EEV.element_entry_value_id)
2501: INTO l_eev_info_changes
2502: FROM pay_element_entry_values_f EEV
2503: WHERE EEV.element_entry_id = p_ele_entry_id
2504: AND EEV.input_value_id = v_inpval_id
2505: AND EEV.effective_start_date <= v_range_start
2506: AND EEV.effective_end_date >= v_range_start

Line 2516: FROM pay_element_entry_values_f EEV

2512: hr_utility.set_location('calculate_period_earnings', 165);
2513:
2514: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2515: INTO v_earnings_entry
2516: FROM pay_element_entry_values_f EEV
2517: WHERE EEV.element_entry_id = p_ele_entry_id
2518: AND EEV.input_value_id = v_inpval_id
2519: AND v_range_end BETWEEN EEV.effective_start_date
2520: AND EEV.effective_end_date;

Line 2680: , pay_element_entry_values_f EEV

2676: l_assignment_id number,
2677: l_input_value_id number) IS
2678: select fnd_number.canonical_to_number (EEV.screen_entry_value)
2679: from pay_element_entries_f EE
2680: , pay_element_entry_values_f EEV
2681: where EEV.input_value_id = l_input_value_id
2682: and l_date_earned BETWEEN EEV.effective_start_date
2683: AND EEV.effective_end_date
2684: and EE.assignment_id = l_assignment_id