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

Line 395: FROM pay_element_entry_values_f EEV

391: p_range_end date) IS
392: SELECT EEV.screen_entry_value,
393: EEV.effective_start_date,
394: EEV.effective_end_date
395: FROM pay_element_entry_values_f EEV
396: WHERE EEV.element_entry_id = p_element_entry_id
397: AND EEV.input_value_id = p_inpval_id
398: AND EEV.effective_start_date > p_range_start
399: AND EEV.effective_end_date <= p_range_end

Line 419: FROM pay_element_entry_values_f EEV

415: EEV.effective_end_date
416: INTO v_earnings_entry,
417: v_entry_start,
418: v_entry_end
419: FROM pay_element_entry_values_f EEV
420: WHERE EEV.element_entry_id = p_element_entry_id
421: AND EEV.input_value_id = p_inpval_id
422: AND EEV.effective_start_date <= p_range_start_date
423: AND EEV.effective_end_date >= p_range_start_date

Line 524: FROM pay_element_entry_values_f EEV

520: LEAST(EEV.effective_end_date, p_range_end_date)
521: INTO v_earnings_entry,
522: v_entry_start,
523: v_entry_end
524: FROM pay_element_entry_values_f EEV
525: WHERE EEV.element_entry_id = p_element_entry_id
526: AND EEV.input_value_id = p_inpval_id
527: AND EEV.effective_start_date > p_range_start_date
528: AND EEV.effective_start_date <= p_range_end_date

Line 588: pay_element_entry_values_f pev

584: v_eff_date DATE) IS
585: select pev.screen_entry_value
586: from per_absence_attendance_types abt,
587: pay_element_entries_f pee,
588: pay_element_entry_values_f pev
589: where pev.input_value_id = abt.input_value_id
590: and abt.absence_category = 'V'
591: and v_eff_date between pev.effective_start_date
592: and pev.effective_end_date

Line 644: pay_element_entry_values_f pev

640: v_eff_date DATE) IS
641: select pev.screen_entry_value
642: from per_absence_attendance_types abt,
643: pay_element_entries_f pee,
644: pay_element_entry_values_f pev
645: where pev.input_value_id = abt.input_value_id
646: and abt.absence_category = 'S'
647: and v_eff_date between pev.effective_start_date
648: and pev.effective_end_date

Line 1030: FROM pay_element_entry_values_f EEV

1026: select 1 INTO l_eev_info_changes
1027: from dual
1028: where exists (
1029: SELECT 1
1030: FROM pay_element_entry_values_f EEV
1031: WHERE EEV.element_entry_id = p_ele_entry_id
1032: AND EEV.input_value_id+0 = v_inpval_id
1033: AND (
1034: (EEV.effective_start_date <= p_period_start

Line 1102: FROM pay_element_entry_values_f EEV

1098: select 1 INTO l_eev_info_changes
1099: from dual
1100: where exists (
1101: SELECT 1
1102: FROM pay_element_entry_values_f EEV
1103: WHERE EEV.element_entry_id = p_ele_entry_id
1104: AND EEV.input_value_id+0 = v_inpval_id
1105: AND EEV.effective_start_date <= p_period_start
1106: AND EEV.effective_end_date >= p_period_start

Line 1147: FROM pay_element_entry_values_f EEV

1143: select 1 INTO l_eev_info_changes
1144: from dual
1145: where exists (
1146: SELECT 1
1147: FROM pay_element_entry_values_f EEV
1148: WHERE EEV.element_entry_id = p_ele_entry_id
1149: AND EEV.input_value_id+0 = v_inpval_id
1150: AND EEV.effective_start_date <= p_period_start
1151: AND EEV.effective_end_date >= p_period_start

Line 1533: FROM pay_element_entry_values_f EEV

1529:
1530: hr_utility.set_location('calculate_period_earnings', 128);
1531: SELECT EEV.screen_entry_value
1532: INTO v_earnings_entry
1533: FROM pay_element_entry_values_f EEV
1534: WHERE EEV.element_entry_id = p_ele_entry_id
1535: AND EEV.input_value_id = v_inpval_id
1536: --bug 5617540 starts
1537: AND p_period_start between EEV.effective_start_date

Line 1603: FROM pay_element_entry_values_f EEV

1599:
1600: hr_utility.set_location('calculate_period_earnings', 132);
1601: SELECT COUNT(EEV.element_entry_value_id)
1602: INTO l_eev_info_changes
1603: FROM pay_element_entry_values_f EEV
1604: WHERE EEV.element_entry_id = p_ele_entry_id
1605: AND EEV.input_value_id = v_inpval_id
1606: AND EEV.effective_start_date <= v_range_start
1607: AND EEV.effective_end_date >= v_range_start

Line 1615: FROM pay_element_entry_values_f EEV

1611: -- Prorate using latest hourly rate:
1612: hr_utility.set_location('calculate_period_earnings', 128);
1613: SELECT EEV.screen_entry_value
1614: INTO v_earnings_entry
1615: FROM pay_element_entry_values_f EEV
1616: WHERE EEV.element_entry_id = p_ele_entry_id
1617: AND EEV.input_value_id = v_inpval_id
1618: AND v_range_end BETWEEN EEV.effective_start_date
1619: AND EEV.effective_end_date;

Line 1715: FROM pay_element_entry_values_f EEV

1711:
1712: hr_utility.set_location('calculate_period_earnings', 133);
1713: SELECT COUNT(EEV.element_entry_value_id)
1714: INTO l_eev_info_changes
1715: FROM pay_element_entry_values_f EEV
1716: WHERE EEV.element_entry_id = p_ele_entry_id
1717: AND EEV.input_value_id = v_inpval_id
1718: AND EEV.effective_start_date <= v_range_start
1719: AND EEV.effective_end_date >= v_range_start

Line 1727: FROM pay_element_entry_values_f EEV

1723: -- Prorate using latest hourly rate:
1724: hr_utility.set_location('calculate_period_earnings', 128);
1725: SELECT EEV.screen_entry_value
1726: INTO v_earnings_entry
1727: FROM pay_element_entry_values_f EEV
1728: WHERE EEV.element_entry_id = p_ele_entry_id
1729: AND EEV.input_value_id = v_inpval_id
1730: AND v_range_end BETWEEN EEV.effective_start_date
1731: AND EEV.effective_end_date;

Line 1844: FROM pay_element_entry_values_f EEV

1840:
1841: hr_utility.set_location('calculate_period_earnings', 133);
1842: SELECT COUNT(EEV.element_entry_value_id)
1843: INTO l_eev_info_changes
1844: FROM pay_element_entry_values_f EEV
1845: WHERE EEV.element_entry_id = p_ele_entry_id
1846: AND EEV.input_value_id = v_inpval_id
1847: AND EEV.effective_start_date <= v_range_start
1848: AND EEV.effective_end_date >= v_range_start

Line 1856: FROM pay_element_entry_values_f EEV

1852: -- Prorate using latest hourly rate (ie. rate as of end of period):
1853: hr_utility.set_location('calculate_period_earnings', 128);
1854: SELECT EEV.screen_entry_value
1855: INTO v_earnings_entry
1856: FROM pay_element_entry_values_f EEV
1857: WHERE EEV.element_entry_id = p_ele_entry_id
1858: AND EEV.input_value_id = v_inpval_id
1859: AND v_range_end BETWEEN EEV.effective_start_date
1860: AND EEV.effective_end_date;

Line 3003: FROM pay_element_entry_values_f EEV,

2999: hr_utility.set_location('Other_Non_Separate_Check', 10);
3000:
3001: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3002: INTO sepcheck_flag
3003: FROM pay_element_entry_values_f EEV,
3004: pay_element_entries_f ELE,
3005: pay_input_values_f IPV
3006: WHERE ELE.assignment_id = p_ass_id
3007: AND p_date_earned

Line 3179: FROM pay_element_entry_values_f EEV,

3175: --
3176: CURSOR get_tew_rate IS
3177: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3178: EEV.element_entry_id
3179: FROM pay_element_entry_values_f EEV,
3180: pay_element_entries_f ELE,
3181: pay_input_values_f IPV
3182: WHERE ELE.assignment_id = p_ass_id
3183: AND ELE.element_entry_id = EEV.element_entry_id

Line 3232: pay_element_entry_values_f eev,

3228: CURSOR get_flat_amounts IS
3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3230: FROM pay_element_links_f pel,
3231: pay_element_entries_f ele,
3232: pay_element_entry_values_f eev,
3233: pay_input_values_f ipv
3234: WHERE pel.element_type_id = v_eletype_id
3235: AND p_date_earned BETWEEN pel.effective_start_date
3236: AND pel.effective_end_date

Line 3251: pay_element_entry_values_f eev,

3247: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3248: EEV.element_entry_id
3249: FROM pay_element_links_f pel,
3250: pay_element_entries_f ele,
3251: pay_element_entry_values_f eev,
3252: pay_input_values_f ipv
3253: WHERE pel.element_type_id = v_eletype_id
3254: AND p_date_earned BETWEEN pel.effective_start_date
3255: AND pel.effective_end_date

Line 3269: pay_element_entry_values_f eev,

3265: CURSOR get_percentages IS
3266: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3267: FROM pay_element_links_f pel,
3268: pay_element_entries_f ele,
3269: pay_element_entry_values_f eev,
3270: pay_input_values_f ipv
3271: WHERE pel.element_type_id = v_eletype_id
3272: AND p_date_earned BETWEEN pel.effective_start_date
3273: AND pel.effective_end_date

Line 3373: FROM pay_element_entry_values_f EEV,

3369: ELSE -- no Rate entered, check Rate Code
3370: hr_utility.set_location('OT_Base_Rate', 15);
3371: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3372: INTO v_tew_rcode
3373: FROM pay_element_entry_values_f EEV,
3374: pay_element_entries_f ELE,
3375: pay_element_types_f ELT,
3376: pay_input_values_f IPV
3377: WHERE ELE.assignment_id = p_ass_id

Line 3412: FROM pay_element_entry_values_f EEV,

3408: IF v_tew_count = 0 THEN -- ie. only use "Regular" rates if TEW not entered.
3409: hr_utility.set_location('OT_Base_Rate', 20);
3410: SELECT COUNT(IPV.input_value_id)
3411: INTO v_use_regwage
3412: FROM pay_element_entry_values_f EEV,
3413: pay_element_entries_f ELE,
3414: pay_input_values_f IPV
3415: WHERE ELE.assignment_id = p_ass_id
3416: AND ELE.element_entry_id = EEV.element_entry_id

Line 3430: FROM pay_element_entry_values_f EEV,

3426: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3427: EEV.element_entry_id
3428: INTO v_regwage_rate,
3429: v_entry_id
3430: FROM pay_element_entry_values_f EEV,
3431: pay_element_entries_f ELE,
3432: pay_input_values_f IPV
3433: WHERE ELE.assignment_id = p_ass_id
3434: AND ELE.element_entry_id = EEV.element_entry_id

Line 3446: FROM pay_element_entry_values_f EEV,

3442: IF v_regwage_rate = 0 THEN
3443: hr_utility.set_location('OT_Base_Rate', 40);
3444: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3445: INTO v_regwage_rcode
3446: FROM pay_element_entry_values_f EEV,
3447: pay_element_entries_f ELE,
3448: pay_element_types_f ELT,
3449: pay_input_values_f IPV
3450: WHERE ELE.assignment_id = p_ass_id

Line 3474: FROM pay_element_entry_values_f EEV,

3470: ELSE
3471: hr_utility.set_location('OT_Base_Rate', 50);
3472: SELECT COUNT(IPV.input_value_id)
3473: INTO v_use_regsal
3474: FROM pay_element_entry_values_f EEV,
3475: pay_element_entries_f ELE,
3476: pay_input_values_f IPV
3477: WHERE ELE.assignment_id = p_ass_id
3478: AND ELE.element_entry_id = EEV.element_entry_id

Line 3490: FROM pay_element_entry_values_f EEV,

3486: IF v_use_regsal <> 0 THEN
3487: hr_utility.set_location('OT_Base_Rate', 51);
3488: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3489: INTO v_regsal_mosal
3490: FROM pay_element_entry_values_f EEV,
3491: pay_element_entries_f ELE,
3492: pay_input_values_f IPV
3493: WHERE ELE.assignment_id = p_ass_id
3494: AND ELE.element_entry_id = EEV.element_entry_id

Line 3612: FROM pay_element_entry_values_f EEV,

3608: IF v_rate = 0 THEN
3609: hr_utility.set_location('OT_Base_Rate', 125);
3610: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3611: INTO v_rate_rcode
3612: FROM pay_element_entry_values_f EEV,
3613: pay_element_entries_f ELE,
3614: pay_element_types_f ELT,
3615: pay_input_values_f IPV
3616: WHERE ELE.assignment_id = p_ass_id

Line 3642: FROM pay_element_entry_values_f EEV,

3638: IF v_rate <> 0 THEN
3639: hr_utility.set_location('OT_Base_Rate', 135);
3640: SELECT COUNT(0)
3641: INTO v_rate_mult_count
3642: FROM pay_element_entry_values_f EEV,
3643: pay_element_entries_f ELE,
3644: pay_element_types_f ELT,
3645: pay_input_values_f IPV
3646: WHERE ELE.assignment_id = p_ass_id

Line 3661: FROM pay_element_entry_values_f EEV,

3657: IF v_rate_mult_count <> 0 THEN
3658: hr_utility.set_location('OT_Base_Rate', 140);
3659: SELECT NVL(EEV.screen_entry_value, 0)
3660: INTO v_rate_multiple
3661: FROM pay_element_entry_values_f EEV,
3662: pay_element_entries_f ELE,
3663: pay_element_types_f ELT,
3664: pay_input_values_f IPV
3665: WHERE ELE.assignment_id = p_ass_id

Line 4379: FROM pay_element_entry_values_f peev

4375: p_bus_grp_id NUMBER,
4376: p_date_earned DATE) IS
4377: SELECT peev.screen_entry_value
4378: ,piv.name
4379: FROM pay_element_entry_values_f peev
4380: ,pay_element_entries_f pee
4381: ,pay_element_links_f pel
4382: ,pay_element_types_f pet
4383: ,pay_input_values_f piv