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

385: p_range_end date) IS
386: SELECT EEV.screen_entry_value,
387: EEV.effective_start_date,
388: EEV.effective_end_date
389: FROM pay_element_entry_values_f EEV
390: WHERE EEV.element_entry_id = p_element_entry_id
391: AND EEV.input_value_id = p_inpval_id
392: AND EEV.effective_start_date > p_range_start
393: AND EEV.effective_end_date <= p_range_end

Line 413: FROM pay_element_entry_values_f EEV

409: EEV.effective_end_date
410: INTO v_earnings_entry,
411: v_entry_start,
412: v_entry_end
413: FROM pay_element_entry_values_f EEV
414: WHERE EEV.element_entry_id = p_element_entry_id
415: AND EEV.input_value_id = p_inpval_id
416: AND EEV.effective_start_date <= p_range_start_date
417: AND EEV.effective_end_date >= p_range_start_date

Line 518: FROM pay_element_entry_values_f EEV

514: LEAST(EEV.effective_end_date, p_range_end_date)
515: INTO v_earnings_entry,
516: v_entry_start,
517: v_entry_end
518: FROM pay_element_entry_values_f EEV
519: WHERE EEV.element_entry_id = p_element_entry_id
520: AND EEV.input_value_id = p_inpval_id
521: AND EEV.effective_start_date > p_range_start_date
522: AND EEV.effective_start_date <= p_range_end_date

Line 582: pay_element_entry_values_f pev

578: v_eff_date DATE) IS
579: select pev.screen_entry_value
580: from per_absence_attendance_types abt,
581: pay_element_entries_f pee,
582: pay_element_entry_values_f pev
583: where pev.input_value_id = abt.input_value_id
584: and abt.absence_category = 'V'
585: and v_eff_date between pev.effective_start_date
586: and pev.effective_end_date

Line 638: pay_element_entry_values_f pev

634: v_eff_date DATE) IS
635: select pev.screen_entry_value
636: from per_absence_attendance_types abt,
637: pay_element_entries_f pee,
638: pay_element_entry_values_f pev
639: where pev.input_value_id = abt.input_value_id
640: and abt.absence_category = 'S'
641: and v_eff_date between pev.effective_start_date
642: and pev.effective_end_date

Line 1024: FROM pay_element_entry_values_f EEV

1020: select 1 INTO l_eev_info_changes
1021: from dual
1022: where exists (
1023: SELECT 1
1024: FROM pay_element_entry_values_f EEV
1025: WHERE EEV.element_entry_id = p_ele_entry_id
1026: AND EEV.input_value_id+0 = v_inpval_id
1027: AND (
1028: (EEV.effective_start_date <= p_period_start

Line 1096: FROM pay_element_entry_values_f EEV

1092: select 1 INTO l_eev_info_changes
1093: from dual
1094: where exists (
1095: SELECT 1
1096: FROM pay_element_entry_values_f EEV
1097: WHERE EEV.element_entry_id = p_ele_entry_id
1098: AND EEV.input_value_id+0 = v_inpval_id
1099: AND EEV.effective_start_date <= p_period_start
1100: AND EEV.effective_end_date >= p_period_start

Line 1141: FROM pay_element_entry_values_f EEV

1137: select 1 INTO l_eev_info_changes
1138: from dual
1139: where exists (
1140: SELECT 1
1141: FROM pay_element_entry_values_f EEV
1142: WHERE EEV.element_entry_id = p_ele_entry_id
1143: AND EEV.input_value_id+0 = v_inpval_id
1144: AND EEV.effective_start_date <= p_period_start
1145: AND EEV.effective_end_date >= p_period_start

Line 1496: FROM pay_element_entry_values_f EEV

1492:
1493: hr_utility.set_location('calculate_period_earnings', 128);
1494: SELECT EEV.screen_entry_value
1495: INTO v_earnings_entry
1496: FROM pay_element_entry_values_f EEV
1497: WHERE EEV.element_entry_id = p_ele_entry_id
1498: AND EEV.input_value_id = v_inpval_id
1499: --bug 5617540 starts
1500: AND p_period_start between EEV.effective_start_date

Line 1566: FROM pay_element_entry_values_f EEV

1562:
1563: hr_utility.set_location('calculate_period_earnings', 132);
1564: SELECT COUNT(EEV.element_entry_value_id)
1565: INTO l_eev_info_changes
1566: FROM pay_element_entry_values_f EEV
1567: WHERE EEV.element_entry_id = p_ele_entry_id
1568: AND EEV.input_value_id = v_inpval_id
1569: AND EEV.effective_start_date <= v_range_start
1570: AND EEV.effective_end_date >= v_range_start

Line 1578: FROM pay_element_entry_values_f EEV

1574: -- Prorate using latest hourly rate:
1575: hr_utility.set_location('calculate_period_earnings', 128);
1576: SELECT EEV.screen_entry_value
1577: INTO v_earnings_entry
1578: FROM pay_element_entry_values_f EEV
1579: WHERE EEV.element_entry_id = p_ele_entry_id
1580: AND EEV.input_value_id = v_inpval_id
1581: AND v_range_end BETWEEN EEV.effective_start_date
1582: AND EEV.effective_end_date;

Line 1678: FROM pay_element_entry_values_f EEV

1674:
1675: hr_utility.set_location('calculate_period_earnings', 133);
1676: SELECT COUNT(EEV.element_entry_value_id)
1677: INTO l_eev_info_changes
1678: FROM pay_element_entry_values_f EEV
1679: WHERE EEV.element_entry_id = p_ele_entry_id
1680: AND EEV.input_value_id = v_inpval_id
1681: AND EEV.effective_start_date <= v_range_start
1682: AND EEV.effective_end_date >= v_range_start

Line 1690: FROM pay_element_entry_values_f EEV

1686: -- Prorate using latest hourly rate:
1687: hr_utility.set_location('calculate_period_earnings', 128);
1688: SELECT EEV.screen_entry_value
1689: INTO v_earnings_entry
1690: FROM pay_element_entry_values_f EEV
1691: WHERE EEV.element_entry_id = p_ele_entry_id
1692: AND EEV.input_value_id = v_inpval_id
1693: AND v_range_end BETWEEN EEV.effective_start_date
1694: AND EEV.effective_end_date;

Line 1807: FROM pay_element_entry_values_f EEV

1803:
1804: hr_utility.set_location('calculate_period_earnings', 133);
1805: SELECT COUNT(EEV.element_entry_value_id)
1806: INTO l_eev_info_changes
1807: FROM pay_element_entry_values_f EEV
1808: WHERE EEV.element_entry_id = p_ele_entry_id
1809: AND EEV.input_value_id = v_inpval_id
1810: AND EEV.effective_start_date <= v_range_start
1811: AND EEV.effective_end_date >= v_range_start

Line 1819: FROM pay_element_entry_values_f EEV

1815: -- Prorate using latest hourly rate (ie. rate as of end of period):
1816: hr_utility.set_location('calculate_period_earnings', 128);
1817: SELECT EEV.screen_entry_value
1818: INTO v_earnings_entry
1819: FROM pay_element_entry_values_f EEV
1820: WHERE EEV.element_entry_id = p_ele_entry_id
1821: AND EEV.input_value_id = v_inpval_id
1822: AND v_range_end BETWEEN EEV.effective_start_date
1823: AND EEV.effective_end_date;

Line 2966: FROM pay_element_entry_values_f EEV,

2962: hr_utility.set_location('Other_Non_Separate_Check', 10);
2963:
2964: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
2965: INTO sepcheck_flag
2966: FROM pay_element_entry_values_f EEV,
2967: pay_element_entries_f ELE,
2968: pay_input_values_f IPV
2969: WHERE ELE.assignment_id = p_ass_id
2970: AND p_date_earned

Line 3142: FROM pay_element_entry_values_f EEV,

3138: --
3139: CURSOR get_tew_rate IS
3140: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3141: EEV.element_entry_id
3142: FROM pay_element_entry_values_f EEV,
3143: pay_element_entries_f ELE,
3144: pay_input_values_f IPV
3145: WHERE ELE.assignment_id = p_ass_id
3146: AND ELE.element_entry_id = EEV.element_entry_id

Line 3195: pay_element_entry_values_f eev,

3191: CURSOR get_flat_amounts IS
3192: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3193: FROM pay_element_links_f pel,
3194: pay_element_entries_f ele,
3195: pay_element_entry_values_f eev,
3196: pay_input_values_f ipv
3197: WHERE pel.element_type_id = v_eletype_id
3198: AND p_date_earned BETWEEN pel.effective_start_date
3199: AND pel.effective_end_date

Line 3214: pay_element_entry_values_f eev,

3210: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3211: EEV.element_entry_id
3212: FROM pay_element_links_f pel,
3213: pay_element_entries_f ele,
3214: pay_element_entry_values_f eev,
3215: pay_input_values_f ipv
3216: WHERE pel.element_type_id = v_eletype_id
3217: AND p_date_earned BETWEEN pel.effective_start_date
3218: AND pel.effective_end_date

Line 3232: pay_element_entry_values_f eev,

3228: CURSOR get_percentages 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 3336: FROM pay_element_entry_values_f EEV,

3332: ELSE -- no Rate entered, check Rate Code
3333: hr_utility.set_location('OT_Base_Rate', 15);
3334: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3335: INTO v_tew_rcode
3336: FROM pay_element_entry_values_f EEV,
3337: pay_element_entries_f ELE,
3338: pay_element_types_f ELT,
3339: pay_input_values_f IPV
3340: WHERE ELE.assignment_id = p_ass_id

Line 3375: FROM pay_element_entry_values_f EEV,

3371: IF v_tew_count = 0 THEN -- ie. only use "Regular" rates if TEW not entered.
3372: hr_utility.set_location('OT_Base_Rate', 20);
3373: SELECT COUNT(IPV.input_value_id)
3374: INTO v_use_regwage
3375: FROM pay_element_entry_values_f EEV,
3376: pay_element_entries_f ELE,
3377: pay_input_values_f IPV
3378: WHERE ELE.assignment_id = p_ass_id
3379: AND ELE.element_entry_id = EEV.element_entry_id

Line 3393: FROM pay_element_entry_values_f EEV,

3389: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3390: EEV.element_entry_id
3391: INTO v_regwage_rate,
3392: v_entry_id
3393: FROM pay_element_entry_values_f EEV,
3394: pay_element_entries_f ELE,
3395: pay_input_values_f IPV
3396: WHERE ELE.assignment_id = p_ass_id
3397: AND ELE.element_entry_id = EEV.element_entry_id

Line 3409: FROM pay_element_entry_values_f EEV,

3405: IF v_regwage_rate = 0 THEN
3406: hr_utility.set_location('OT_Base_Rate', 40);
3407: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3408: INTO v_regwage_rcode
3409: FROM pay_element_entry_values_f EEV,
3410: pay_element_entries_f ELE,
3411: pay_element_types_f ELT,
3412: pay_input_values_f IPV
3413: WHERE ELE.assignment_id = p_ass_id

Line 3437: FROM pay_element_entry_values_f EEV,

3433: ELSE
3434: hr_utility.set_location('OT_Base_Rate', 50);
3435: SELECT COUNT(IPV.input_value_id)
3436: INTO v_use_regsal
3437: FROM pay_element_entry_values_f EEV,
3438: pay_element_entries_f ELE,
3439: pay_input_values_f IPV
3440: WHERE ELE.assignment_id = p_ass_id
3441: AND ELE.element_entry_id = EEV.element_entry_id

Line 3453: FROM pay_element_entry_values_f EEV,

3449: IF v_use_regsal <> 0 THEN
3450: hr_utility.set_location('OT_Base_Rate', 51);
3451: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3452: INTO v_regsal_mosal
3453: FROM pay_element_entry_values_f EEV,
3454: pay_element_entries_f ELE,
3455: pay_input_values_f IPV
3456: WHERE ELE.assignment_id = p_ass_id
3457: AND ELE.element_entry_id = EEV.element_entry_id

Line 3575: FROM pay_element_entry_values_f EEV,

3571: IF v_rate = 0 THEN
3572: hr_utility.set_location('OT_Base_Rate', 125);
3573: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3574: INTO v_rate_rcode
3575: FROM pay_element_entry_values_f EEV,
3576: pay_element_entries_f ELE,
3577: pay_element_types_f ELT,
3578: pay_input_values_f IPV
3579: WHERE ELE.assignment_id = p_ass_id

Line 3605: FROM pay_element_entry_values_f EEV,

3601: IF v_rate <> 0 THEN
3602: hr_utility.set_location('OT_Base_Rate', 135);
3603: SELECT COUNT(0)
3604: INTO v_rate_mult_count
3605: FROM pay_element_entry_values_f EEV,
3606: pay_element_entries_f ELE,
3607: pay_element_types_f ELT,
3608: pay_input_values_f IPV
3609: WHERE ELE.assignment_id = p_ass_id

Line 3624: FROM pay_element_entry_values_f EEV,

3620: IF v_rate_mult_count <> 0 THEN
3621: hr_utility.set_location('OT_Base_Rate', 140);
3622: SELECT NVL(EEV.screen_entry_value, 0)
3623: INTO v_rate_multiple
3624: FROM pay_element_entry_values_f EEV,
3625: pay_element_entries_f ELE,
3626: pay_element_types_f ELT,
3627: pay_input_values_f IPV
3628: WHERE ELE.assignment_id = p_ass_id

Line 4342: FROM pay_element_entry_values_f peev

4338: p_bus_grp_id NUMBER,
4339: p_date_earned DATE) IS
4340: SELECT peev.screen_entry_value
4341: ,piv.name
4342: FROM pay_element_entry_values_f peev
4343: ,pay_element_entries_f pee
4344: ,pay_element_links_f pel
4345: ,pay_element_types_f pet
4346: ,pay_input_values_f piv