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

Line 652: FROM pay_element_entry_values_f EEV

648: p_range_end date) IS
649: SELECT EEV.screen_entry_value,
650: EEV.effective_start_date,
651: EEV.effective_end_date
652: FROM pay_element_entry_values_f EEV
653: WHERE EEV.element_entry_id = p_element_entry_id
654: AND EEV.input_value_id = p_inpval_id
655: AND EEV.effective_start_date > p_range_start
656: AND EEV.effective_end_date <= p_range_end

Line 695: FROM pay_element_entry_values_f EEV

691: EEV.effective_end_date
692: INTO v_earnings_entry,
693: v_entry_start,
694: v_entry_end
695: FROM pay_element_entry_values_f EEV
696: WHERE EEV.element_entry_id = p_element_entry_id
697: AND EEV.input_value_id = p_inpval_id
698: AND EEV.effective_start_date <= p_range_start_date
699: AND EEV.effective_end_date >= p_range_start_date

Line 800: FROM pay_element_entry_values_f EEV

796: LEAST(EEV.effective_end_date, p_range_end_date)
797: INTO v_earnings_entry,
798: v_entry_start,
799: v_entry_end
800: FROM pay_element_entry_values_f EEV
801: WHERE EEV.element_entry_id = p_element_entry_id
802: AND EEV.input_value_id = p_inpval_id
803: AND EEV.effective_start_date > p_range_start_date
804: AND EEV.effective_start_date <= p_range_end_date

Line 878: pay_element_entry_values_f pev

874: v_eff_date DATE) IS
875: select fnd_number.canonical_to_number(pev.screen_entry_value)
876: from per_absence_attendance_types abt,
877: pay_element_entries_f pee,
878: pay_element_entry_values_f pev
879: where pev.input_value_id = abt.input_value_id
880: and abt.absence_category = 'V'
881: and v_eff_date between pev.effective_start_date
882: and pev.effective_end_date

Line 944: pay_element_entry_values_f pev

940: v_eff_date DATE) IS
941: select fnd_number.canonical_to_number(pev.screen_entry_value)
942: from per_absence_attendance_types abt,
943: pay_element_entries_f pee,
944: pay_element_entry_values_f pev
945: where pev.input_value_id = abt.input_value_id
946: and abt.absence_category = 'S'
947: and v_eff_date between pev.effective_start_date
948: and pev.effective_end_date

Line 1391: FROM pay_element_entry_values_f EEV

1387: select 1 INTO l_eev_info_changes
1388: from dual
1389: where exists (
1390: SELECT 1
1391: FROM pay_element_entry_values_f EEV
1392: WHERE EEV.element_entry_id = p_ele_entry_id
1393: AND EEV.input_value_id+0 = v_inpval_id
1394: AND ( ( EEV.effective_start_date <= p_period_start
1395: AND EEV.effective_end_date >= p_period_start

Line 1459: FROM pay_element_entry_values_f EEV

1455: select 1 INTO l_eev_info_changes
1456: from dual
1457: where exists (
1458: SELECT 1
1459: FROM pay_element_entry_values_f EEV
1460: WHERE EEV.element_entry_id = p_ele_entry_id
1461: AND EEV.input_value_id+0 = v_inpval_id
1462: AND ( ( EEV.effective_start_date <= p_period_start
1463: AND EEV.effective_end_date >= p_period_start

Line 1506: FROM pay_element_entry_values_f EEV

1502: select 1 INTO l_eev_info_changes
1503: from dual
1504: where exists (
1505: SELECT 1
1506: FROM pay_element_entry_values_f EEV
1507: WHERE EEV.element_entry_id = p_ele_entry_id
1508: AND EEV.input_value_id+0 = v_inpval_id
1509: AND EEV.effective_start_date <= p_period_start
1510: AND EEV.effective_end_date >= p_period_start

Line 1833: FROM pay_element_entry_values_f EEV

1829: hr_utility.set_location('calculate_period_earnings', 128);
1830:
1831: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1832: INTO v_earnings_entry
1833: FROM pay_element_entry_values_f EEV
1834: WHERE EEV.element_entry_id = p_ele_entry_id
1835: AND EEV.input_value_id = v_inpval_id
1836: AND p_period_start between EEV.effective_start_date
1837: AND EEV.effective_end_date;

Line 1892: FROM pay_element_entry_values_f EEV

1888: hr_utility.set_location('calculate_period_earnings', 130);
1889:
1890: SELECT COUNT(EEV.element_entry_value_id)
1891: INTO l_eev_info_changes
1892: FROM pay_element_entry_values_f EEV
1893: WHERE EEV.element_entry_id = p_ele_entry_id
1894: AND EEV.input_value_id = v_inpval_id
1895: AND EEV.effective_start_date <= v_range_start
1896: AND EEV.effective_end_date >= v_range_start

Line 1907: FROM pay_element_entry_values_f EEV

1903: hr_utility.set_location('calculate_period_earnings', 132);
1904:
1905: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1906: INTO v_earnings_entry
1907: FROM pay_element_entry_values_f EEV
1908: WHERE EEV.element_entry_id = p_ele_entry_id
1909: AND EEV.input_value_id = v_inpval_id
1910: AND v_range_end BETWEEN EEV.effective_start_date
1911: AND EEV.effective_end_date;

Line 1995: FROM pay_element_entry_values_f EEV

1991: hr_utility.set_location('calculate_period_earnings', 145);
1992:
1993: SELECT COUNT(EEV.element_entry_value_id)
1994: INTO l_eev_info_changes
1995: FROM pay_element_entry_values_f EEV
1996: WHERE EEV.element_entry_id = p_ele_entry_id
1997: AND EEV.input_value_id = v_inpval_id
1998: AND EEV.effective_start_date <= v_range_start
1999: AND EEV.effective_end_date >= v_range_start

Line 2009: FROM pay_element_entry_values_f EEV

2005:
2006: hr_utility.trace('BOTH ASG - EEV false');
2007: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2008: INTO v_earnings_entry
2009: FROM pay_element_entry_values_f EEV
2010: WHERE EEV.element_entry_id = p_ele_entry_id
2011: AND EEV.input_value_id = v_inpval_id
2012: AND v_range_end BETWEEN EEV.effective_start_date
2013: AND EEV.effective_end_date;

Line 2100: FROM pay_element_entry_values_f EEV

2096: hr_utility.trace('SELECT EEVMPE');
2097:
2098: SELECT COUNT(EEV.element_entry_value_id)
2099: INTO l_eev_info_changes
2100: FROM pay_element_entry_values_f EEV
2101: WHERE EEV.element_entry_id = p_ele_entry_id
2102: AND EEV.input_value_id = v_inpval_id
2103: AND EEV.effective_start_date <= v_range_start
2104: AND EEV.effective_end_date >= v_range_start

Line 2114: FROM pay_element_entry_values_f EEV

2110: hr_utility.set_location('calculate_period_earnings', 165);
2111:
2112: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2113: INTO v_earnings_entry
2114: FROM pay_element_entry_values_f EEV
2115: WHERE EEV.element_entry_id = p_ele_entry_id
2116: AND EEV.input_value_id = v_inpval_id
2117: AND v_range_end BETWEEN EEV.effective_start_date
2118: AND EEV.effective_end_date;

Line 3320: FROM pay_element_entry_values_f EEV,

3316: hr_utility.set_location('Other_Non_Separate_Check', 10);
3317:
3318: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3319: INTO sepcheck_flag
3320: FROM pay_element_entry_values_f EEV,
3321: pay_element_entries_f ELE,
3322: pay_input_values_f IPV
3323: WHERE ELE.assignment_id = p_ass_id
3324: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3483: pay_element_entry_values_f EEV,

3479: CURSOR get_tew_rate IS
3480: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3481: EEV.element_entry_id
3482: FROM pay_element_entries_f ELE,
3483: pay_element_entry_values_f EEV,
3484: pay_input_values_f IPV,
3485: pay_element_types_f ELT
3486: WHERE ELE.assignment_id = p_ass_id
3487: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3505: FROM pay_element_entry_values_f EEV,

3501: AND IPV.name = 'Rate';
3502: --
3503: /* CURSOR get_tew_rcode IS
3504: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3505: FROM pay_element_entry_values_f EEV,
3506: pay_element_entries_f ELE,
3507: pay_element_types_f ELT,
3508: pay_input_values_f IPV
3509: WHERE ELE.assignment_id = p_ass_id

Line 3562: pay_element_entry_values_f eev,

3558: CURSOR get_flat_amounts IS
3559: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3560: FROM pay_element_links_f pel,
3561: pay_element_entries_f ele,
3562: pay_element_entry_values_f eev,
3563: pay_input_values_f ipv
3564: WHERE pel.element_type_id = v_eletype_id
3565: AND p_date_earned BETWEEN pel.effective_start_date
3566: AND pel.effective_end_date

Line 3581: pay_element_entry_values_f eev,

3577: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3578: EEV.element_entry_id
3579: FROM pay_element_links_f pel,
3580: pay_element_entries_f ele,
3581: pay_element_entry_values_f eev,
3582: pay_input_values_f ipv
3583: WHERE pel.element_type_id = v_eletype_id
3584: AND p_date_earned BETWEEN pel.effective_start_date
3585: AND pel.effective_end_date

Line 3599: pay_element_entry_values_f eev,

3595: CURSOR get_percentages IS
3596: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3597: FROM pay_element_links_f pel,
3598: pay_element_entries_f ele,
3599: pay_element_entry_values_f eev,
3600: pay_input_values_f ipv
3601: WHERE pel.element_type_id = v_eletype_id
3602: AND p_date_earned BETWEEN pel.effective_start_date
3603: AND pel.effective_end_date

Line 3714: pay_element_entry_values_f EEV,

3710: hr_utility.set_location('OT_Base_Rate', 15);
3711: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3712: INTO v_tew_rcode
3713: FROM pay_element_entries_f ELE,
3714: pay_element_entry_values_f EEV,
3715: pay_input_values_f IPV,
3716: pay_element_types_f ELT
3717: WHERE ELE.assignment_id = p_ass_id
3718: AND EEV.element_entry_id = v_entry_id

Line 3759: pay_element_entry_values_f EEV,

3755: hr_utility.set_location('OT_Base_Rate', 20);
3756: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3757: INTO v_use_regwage
3758: FROM pay_element_entries_f ELE,
3759: pay_element_entry_values_f EEV,
3760: pay_input_values_f IPV,
3761: pay_element_types_f ELT
3762: WHERE ELE.assignment_id = p_ass_id
3763: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3787: pay_element_entry_values_f EEV,

3783: EEV.element_entry_id
3784: INTO v_regwage_rate,
3785: v_entry_id
3786: FROM pay_element_entries_f ELE,
3787: pay_element_entry_values_f EEV,
3788: pay_input_values_f IPV,
3789: pay_element_types_f ELT
3790: WHERE ELE.assignment_id = p_ass_id
3791: AND p_date_earned BETWEEN ele.effective_start_date

Line 3813: pay_element_entry_values_f EEV,

3809: hr_utility.set_location('OT_Base_Rate', 40);
3810: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3811: INTO v_regwage_rcode
3812: FROM pay_element_entries_f ELE,
3813: pay_element_entry_values_f EEV,
3814: pay_input_values_f IPV,
3815: pay_element_types_f ELT
3816: WHERE ELE.assignment_id = p_ass_id
3817: AND p_date_earned between ELE.effective_start_date

Line 3849: pay_element_entry_values_f EEV,

3845: hr_utility.set_location('OT_Base_Rate', 50);
3846: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3847: INTO v_use_regsal
3848: FROM pay_element_entries_f ELE,
3849: pay_element_entry_values_f EEV,
3850: pay_input_values_f IPV,
3851: pay_element_types_f ELT
3852: WHERE ELE.assignment_id = p_ass_id
3853: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3875: pay_element_entry_values_f EEV,

3871: hr_utility.set_location('OT_Base_Rate', 51);
3872: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3873: INTO v_regsal_mosal
3874: FROM pay_element_entries_f ELE,
3875: pay_element_entry_values_f EEV,
3876: pay_input_values_f IPV,
3877: pay_element_types_f ELT
3878: WHERE ELE.assignment_id = p_ass_id
3879: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3998: FROM pay_element_entry_values_f EEV,

3994: IF v_rate = 0 THEN
3995: hr_utility.set_location('OT_Base_Rate', 125);
3996: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3997: INTO v_rate_rcode
3998: FROM pay_element_entry_values_f EEV,
3999: pay_element_entries_f ELE,
4000: pay_element_types_f ELT,
4001: pay_input_values_f IPV
4002: WHERE ELE.assignment_id = p_ass_id

Line 4027: FROM pay_element_entry_values_f EEV,

4023: IF v_rate <> 0 THEN
4024: hr_utility.set_location('OT_Base_Rate', 135);
4025: SELECT COUNT(0)
4026: INTO v_rate_mult_count
4027: FROM pay_element_entry_values_f EEV,
4028: pay_element_entries_f ELE,
4029: pay_element_types_f ELT,
4030: pay_input_values_f IPV
4031: WHERE ELE.assignment_id = p_ass_id

Line 4045: FROM pay_element_entry_values_f EEV,

4041: IF v_rate_mult_count <> 0 THEN
4042: hr_utility.set_location('OT_Base_Rate', 140);
4043: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
4044: INTO v_rate_multiple
4045: FROM pay_element_entry_values_f EEV,
4046: pay_element_entries_f ELE,
4047: pay_element_types_f ELT,
4048: pay_input_values_f IPV
4049: WHERE ELE.assignment_id = p_ass_id

Line 4591: from PAY_ELEMENT_ENTRY_VALUES_F eev , PAY_INPUT_VALUES_F ip

4587: and rcu.retro_component_usage_id = pes.retro_component_usage_id
4588: and pes.legislation_code is null ; */
4589:
4590: select (sum(to_number(nvl(screen_entry_value,'0')))) into l_arrear_contr_value
4591: from PAY_ELEMENT_ENTRY_VALUES_F eev , PAY_INPUT_VALUES_F ip
4592: where eev.input_value_id = ip.input_value_id
4593: and ip.name like 'Arrears Contr'
4594: and element_entry_id in ( select element_entry_id -- element entry for arrear contr
4595: from pay_element_entries_f