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

639: p_range_end date) IS
640: SELECT EEV.screen_entry_value,
641: EEV.effective_start_date,
642: EEV.effective_end_date
643: FROM pay_element_entry_values_f EEV
644: WHERE EEV.element_entry_id = p_element_entry_id
645: AND EEV.input_value_id = p_inpval_id
646: AND EEV.effective_start_date > p_range_start
647: AND EEV.effective_end_date <= p_range_end

Line 686: FROM pay_element_entry_values_f EEV

682: EEV.effective_end_date
683: INTO v_earnings_entry,
684: v_entry_start,
685: v_entry_end
686: FROM pay_element_entry_values_f EEV
687: WHERE EEV.element_entry_id = p_element_entry_id
688: AND EEV.input_value_id = p_inpval_id
689: AND EEV.effective_start_date <= p_range_start_date
690: AND EEV.effective_end_date >= p_range_start_date

Line 791: FROM pay_element_entry_values_f EEV

787: LEAST(EEV.effective_end_date, p_range_end_date)
788: INTO v_earnings_entry,
789: v_entry_start,
790: v_entry_end
791: FROM pay_element_entry_values_f EEV
792: WHERE EEV.element_entry_id = p_element_entry_id
793: AND EEV.input_value_id = p_inpval_id
794: AND EEV.effective_start_date > p_range_start_date
795: AND EEV.effective_start_date <= p_range_end_date

Line 869: pay_element_entry_values_f pev

865: v_eff_date DATE) IS
866: select fnd_number.canonical_to_number(pev.screen_entry_value)
867: from per_absence_attendance_types abt,
868: pay_element_entries_f pee,
869: pay_element_entry_values_f pev
870: where pev.input_value_id = abt.input_value_id
871: and abt.absence_category = 'V'
872: and v_eff_date between pev.effective_start_date
873: and pev.effective_end_date

Line 935: pay_element_entry_values_f pev

931: v_eff_date DATE) IS
932: select fnd_number.canonical_to_number(pev.screen_entry_value)
933: from per_absence_attendance_types abt,
934: pay_element_entries_f pee,
935: pay_element_entry_values_f pev
936: where pev.input_value_id = abt.input_value_id
937: and abt.absence_category = 'S'
938: and v_eff_date between pev.effective_start_date
939: and pev.effective_end_date

Line 1382: FROM pay_element_entry_values_f EEV

1378: select 1 INTO l_eev_info_changes
1379: from dual
1380: where exists (
1381: SELECT 1
1382: FROM pay_element_entry_values_f EEV
1383: WHERE EEV.element_entry_id = p_ele_entry_id
1384: AND EEV.input_value_id+0 = v_inpval_id
1385: AND ( ( EEV.effective_start_date <= p_period_start
1386: AND EEV.effective_end_date >= p_period_start

Line 1450: FROM pay_element_entry_values_f EEV

1446: select 1 INTO l_eev_info_changes
1447: from dual
1448: where exists (
1449: SELECT 1
1450: FROM pay_element_entry_values_f EEV
1451: WHERE EEV.element_entry_id = p_ele_entry_id
1452: AND EEV.input_value_id+0 = v_inpval_id
1453: AND ( ( EEV.effective_start_date <= p_period_start
1454: AND EEV.effective_end_date >= p_period_start

Line 1497: FROM pay_element_entry_values_f EEV

1493: select 1 INTO l_eev_info_changes
1494: from dual
1495: where exists (
1496: SELECT 1
1497: FROM pay_element_entry_values_f EEV
1498: WHERE EEV.element_entry_id = p_ele_entry_id
1499: AND EEV.input_value_id+0 = v_inpval_id
1500: AND EEV.effective_start_date <= p_period_start
1501: AND EEV.effective_end_date >= p_period_start

Line 1824: FROM pay_element_entry_values_f EEV

1820: hr_utility.set_location('calculate_period_earnings', 128);
1821:
1822: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1823: INTO v_earnings_entry
1824: FROM pay_element_entry_values_f EEV
1825: WHERE EEV.element_entry_id = p_ele_entry_id
1826: AND EEV.input_value_id = v_inpval_id
1827: AND p_period_start between EEV.effective_start_date
1828: AND EEV.effective_end_date;

Line 1883: FROM pay_element_entry_values_f EEV

1879: hr_utility.set_location('calculate_period_earnings', 130);
1880:
1881: SELECT COUNT(EEV.element_entry_value_id)
1882: INTO l_eev_info_changes
1883: FROM pay_element_entry_values_f EEV
1884: WHERE EEV.element_entry_id = p_ele_entry_id
1885: AND EEV.input_value_id = v_inpval_id
1886: AND EEV.effective_start_date <= v_range_start
1887: AND EEV.effective_end_date >= v_range_start

Line 1898: FROM pay_element_entry_values_f EEV

1894: hr_utility.set_location('calculate_period_earnings', 132);
1895:
1896: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1897: INTO v_earnings_entry
1898: FROM pay_element_entry_values_f EEV
1899: WHERE EEV.element_entry_id = p_ele_entry_id
1900: AND EEV.input_value_id = v_inpval_id
1901: AND v_range_end BETWEEN EEV.effective_start_date
1902: AND EEV.effective_end_date;

Line 1986: FROM pay_element_entry_values_f EEV

1982: hr_utility.set_location('calculate_period_earnings', 145);
1983:
1984: SELECT COUNT(EEV.element_entry_value_id)
1985: INTO l_eev_info_changes
1986: FROM pay_element_entry_values_f EEV
1987: WHERE EEV.element_entry_id = p_ele_entry_id
1988: AND EEV.input_value_id = v_inpval_id
1989: AND EEV.effective_start_date <= v_range_start
1990: AND EEV.effective_end_date >= v_range_start

Line 2000: FROM pay_element_entry_values_f EEV

1996:
1997: hr_utility.trace('BOTH ASG - EEV false');
1998: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1999: INTO v_earnings_entry
2000: FROM pay_element_entry_values_f EEV
2001: WHERE EEV.element_entry_id = p_ele_entry_id
2002: AND EEV.input_value_id = v_inpval_id
2003: AND v_range_end BETWEEN EEV.effective_start_date
2004: AND EEV.effective_end_date;

Line 2091: FROM pay_element_entry_values_f EEV

2087: hr_utility.trace('SELECT EEVMPE');
2088:
2089: SELECT COUNT(EEV.element_entry_value_id)
2090: INTO l_eev_info_changes
2091: FROM pay_element_entry_values_f EEV
2092: WHERE EEV.element_entry_id = p_ele_entry_id
2093: AND EEV.input_value_id = v_inpval_id
2094: AND EEV.effective_start_date <= v_range_start
2095: AND EEV.effective_end_date >= v_range_start

Line 2105: FROM pay_element_entry_values_f EEV

2101: hr_utility.set_location('calculate_period_earnings', 165);
2102:
2103: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2104: INTO v_earnings_entry
2105: FROM pay_element_entry_values_f EEV
2106: WHERE EEV.element_entry_id = p_ele_entry_id
2107: AND EEV.input_value_id = v_inpval_id
2108: AND v_range_end BETWEEN EEV.effective_start_date
2109: AND EEV.effective_end_date;

Line 3311: FROM pay_element_entry_values_f EEV,

3307: hr_utility.set_location('Other_Non_Separate_Check', 10);
3308:
3309: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3310: INTO sepcheck_flag
3311: FROM pay_element_entry_values_f EEV,
3312: pay_element_entries_f ELE,
3313: pay_input_values_f IPV
3314: WHERE ELE.assignment_id = p_ass_id
3315: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3474: pay_element_entry_values_f EEV,

3470: CURSOR get_tew_rate IS
3471: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3472: EEV.element_entry_id
3473: FROM pay_element_entries_f ELE,
3474: pay_element_entry_values_f EEV,
3475: pay_input_values_f IPV,
3476: pay_element_types_f ELT
3477: WHERE ELE.assignment_id = p_ass_id
3478: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3496: FROM pay_element_entry_values_f EEV,

3492: AND IPV.name = 'Rate';
3493: --
3494: /* CURSOR get_tew_rcode IS
3495: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3496: FROM pay_element_entry_values_f EEV,
3497: pay_element_entries_f ELE,
3498: pay_element_types_f ELT,
3499: pay_input_values_f IPV
3500: WHERE ELE.assignment_id = p_ass_id

Line 3553: pay_element_entry_values_f eev,

3549: CURSOR get_flat_amounts IS
3550: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3551: FROM pay_element_links_f pel,
3552: pay_element_entries_f ele,
3553: pay_element_entry_values_f eev,
3554: pay_input_values_f ipv
3555: WHERE pel.element_type_id = v_eletype_id
3556: AND p_date_earned BETWEEN pel.effective_start_date
3557: AND pel.effective_end_date

Line 3572: pay_element_entry_values_f eev,

3568: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3569: EEV.element_entry_id
3570: FROM pay_element_links_f pel,
3571: pay_element_entries_f ele,
3572: pay_element_entry_values_f eev,
3573: pay_input_values_f ipv
3574: WHERE pel.element_type_id = v_eletype_id
3575: AND p_date_earned BETWEEN pel.effective_start_date
3576: AND pel.effective_end_date

Line 3590: pay_element_entry_values_f eev,

3586: CURSOR get_percentages IS
3587: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3588: FROM pay_element_links_f pel,
3589: pay_element_entries_f ele,
3590: pay_element_entry_values_f eev,
3591: pay_input_values_f ipv
3592: WHERE pel.element_type_id = v_eletype_id
3593: AND p_date_earned BETWEEN pel.effective_start_date
3594: AND pel.effective_end_date

Line 3705: pay_element_entry_values_f EEV,

3701: hr_utility.set_location('OT_Base_Rate', 15);
3702: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3703: INTO v_tew_rcode
3704: FROM pay_element_entries_f ELE,
3705: pay_element_entry_values_f EEV,
3706: pay_input_values_f IPV,
3707: pay_element_types_f ELT
3708: WHERE ELE.assignment_id = p_ass_id
3709: AND EEV.element_entry_id = v_entry_id

Line 3750: pay_element_entry_values_f EEV,

3746: hr_utility.set_location('OT_Base_Rate', 20);
3747: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3748: INTO v_use_regwage
3749: FROM pay_element_entries_f ELE,
3750: pay_element_entry_values_f EEV,
3751: pay_input_values_f IPV,
3752: pay_element_types_f ELT
3753: WHERE ELE.assignment_id = p_ass_id
3754: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3778: pay_element_entry_values_f EEV,

3774: EEV.element_entry_id
3775: INTO v_regwage_rate,
3776: v_entry_id
3777: FROM pay_element_entries_f ELE,
3778: pay_element_entry_values_f EEV,
3779: pay_input_values_f IPV,
3780: pay_element_types_f ELT
3781: WHERE ELE.assignment_id = p_ass_id
3782: AND p_date_earned BETWEEN ele.effective_start_date

Line 3804: pay_element_entry_values_f EEV,

3800: hr_utility.set_location('OT_Base_Rate', 40);
3801: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3802: INTO v_regwage_rcode
3803: FROM pay_element_entries_f ELE,
3804: pay_element_entry_values_f EEV,
3805: pay_input_values_f IPV,
3806: pay_element_types_f ELT
3807: WHERE ELE.assignment_id = p_ass_id
3808: AND p_date_earned between ELE.effective_start_date

Line 3840: pay_element_entry_values_f EEV,

3836: hr_utility.set_location('OT_Base_Rate', 50);
3837: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3838: INTO v_use_regsal
3839: FROM pay_element_entries_f ELE,
3840: pay_element_entry_values_f EEV,
3841: pay_input_values_f IPV,
3842: pay_element_types_f ELT
3843: WHERE ELE.assignment_id = p_ass_id
3844: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3866: pay_element_entry_values_f EEV,

3862: hr_utility.set_location('OT_Base_Rate', 51);
3863: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3864: INTO v_regsal_mosal
3865: FROM pay_element_entries_f ELE,
3866: pay_element_entry_values_f EEV,
3867: pay_input_values_f IPV,
3868: pay_element_types_f ELT
3869: WHERE ELE.assignment_id = p_ass_id
3870: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3989: FROM pay_element_entry_values_f EEV,

3985: IF v_rate = 0 THEN
3986: hr_utility.set_location('OT_Base_Rate', 125);
3987: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3988: INTO v_rate_rcode
3989: FROM pay_element_entry_values_f EEV,
3990: pay_element_entries_f ELE,
3991: pay_element_types_f ELT,
3992: pay_input_values_f IPV
3993: WHERE ELE.assignment_id = p_ass_id

Line 4018: FROM pay_element_entry_values_f EEV,

4014: IF v_rate <> 0 THEN
4015: hr_utility.set_location('OT_Base_Rate', 135);
4016: SELECT COUNT(0)
4017: INTO v_rate_mult_count
4018: FROM pay_element_entry_values_f EEV,
4019: pay_element_entries_f ELE,
4020: pay_element_types_f ELT,
4021: pay_input_values_f IPV
4022: WHERE ELE.assignment_id = p_ass_id

Line 4036: FROM pay_element_entry_values_f EEV,

4032: IF v_rate_mult_count <> 0 THEN
4033: hr_utility.set_location('OT_Base_Rate', 140);
4034: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
4035: INTO v_rate_multiple
4036: FROM pay_element_entry_values_f EEV,
4037: pay_element_entries_f ELE,
4038: pay_element_types_f ELT,
4039: pay_input_values_f IPV
4040: WHERE ELE.assignment_id = p_ass_id