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_ENTRIES_F

Line 877: pay_element_entries_f pee,

873: CURSOR get_vac_hours ( v_asg_id NUMBER,
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

Line 943: pay_element_entries_f pee,

939: CURSOR get_sick_hours ( v_asg_id NUMBER,
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

Line 3010: FROM PAY_ELEMENT_ENTRIES_F ELE,

3006: hr_utility.trace('UDFS Entered chained_element_exists');
3007:
3008: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3009: INTO v_ele_exists
3010: FROM PAY_ELEMENT_ENTRIES_F ELE,
3011: PAY_ELEMENT_LINKS_F ELI,
3012: PAY_ELEMENT_TYPES_F ELT
3013: WHERE p_date_earned BETWEEN ELE.effective_start_date
3014: AND ELE.effective_end_date

Line 3321: pay_element_entries_f ELE,

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
3325: AND ELE.effective_end_date

Line 3342: FROM pay_element_entries_f ELE,

3338: hr_utility.set_location('Other_Non_Separate_Check', 20);
3339:
3340: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3341: INTO sepcheck_flag
3342: FROM pay_element_entries_f ELE,
3343: pay_element_links_f ELL,
3344: pay_element_types_f ELT,
3345: pay_element_classifications ECL
3346: WHERE ELE.assignment_id = p_ass_id

Line 3482: FROM pay_element_entries_f ELE,

3478: --
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

Line 3506: pay_element_entries_f ELE,

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
3510: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3533: FROM pay_element_entries_f ELE,

3529: CURSOR get_include_in_ot IS
3530: SELECT ELT.element_type_id,
3531: ELT.element_name,
3532: FRA.formula_name
3533: FROM pay_element_entries_f ELE,
3534: pay_element_links_f ELI,
3535: pay_element_types_f ELT,
3536: pay_status_processing_rules_f SPR,
3537: ff_formulas_f FRA

Line 3561: pay_element_entries_f ele,

3557: -- the period:
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

Line 3580: pay_element_entries_f ele,

3576: CURSOR get_rates IS
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

Line 3598: pay_element_entries_f ele,

3594: --
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

Line 3713: FROM pay_element_entries_f ELE,

3709: ELSE -- no Rate entered, check Rate Code
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

Line 3758: FROM pay_element_entries_f ELE,

3754: IF v_tew_count = 0 THEN -- ie. only use "Regular" rates if TEW not entered.
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

Line 3786: FROM pay_element_entries_f ELE,

3782: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
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

Line 3812: FROM pay_element_entries_f ELE,

3808: IF v_regwage_rate = 0 THEN
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

Line 3848: FROM pay_element_entries_f ELE,

3844: ELSE
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

Line 3874: FROM pay_element_entries_f ELE,

3870: IF v_use_regsal <> 0 THEN
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

Line 3999: pay_element_entries_f ELE,

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
4003: AND ELE.element_entry_id = EEV.element_entry_id

Line 4028: pay_element_entries_f ELE,

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
4032: AND ELE.element_entry_id = EEV.element_entry_id

Line 4046: pay_element_entries_f ELE,

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
4050: AND ELE.element_entry_id = EEV.element_entry_id

Line 4595: from pay_element_entries_f

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
4596: where assignment_id = p_assignment_id
4597: and p_date_earned between effective_start_date and effective_end_date
4598: and element_type_id = l_arr_eletype_id );
4599: