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 868: pay_element_entries_f pee,

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

Line 934: pay_element_entries_f pee,

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

Line 3001: FROM PAY_ELEMENT_ENTRIES_F ELE,

2997: hr_utility.trace('UDFS Entered chained_element_exists');
2998:
2999: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3000: INTO v_ele_exists
3001: FROM PAY_ELEMENT_ENTRIES_F ELE,
3002: PAY_ELEMENT_LINKS_F ELI,
3003: PAY_ELEMENT_TYPES_F ELT
3004: WHERE p_date_earned BETWEEN ELE.effective_start_date
3005: AND ELE.effective_end_date

Line 3312: pay_element_entries_f ELE,

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

Line 3333: FROM pay_element_entries_f ELE,

3329: hr_utility.set_location('Other_Non_Separate_Check', 20);
3330:
3331: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3332: INTO sepcheck_flag
3333: FROM pay_element_entries_f ELE,
3334: pay_element_links_f ELL,
3335: pay_element_types_f ELT,
3336: pay_element_classifications ECL
3337: WHERE ELE.assignment_id = p_ass_id

Line 3473: FROM pay_element_entries_f ELE,

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

Line 3497: pay_element_entries_f ELE,

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

Line 3524: FROM pay_element_entries_f ELE,

3520: CURSOR get_include_in_ot IS
3521: SELECT ELT.element_type_id,
3522: ELT.element_name,
3523: FRA.formula_name
3524: FROM pay_element_entries_f ELE,
3525: pay_element_links_f ELI,
3526: pay_element_types_f ELT,
3527: pay_status_processing_rules_f SPR,
3528: ff_formulas_f FRA

Line 3552: pay_element_entries_f ele,

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

Line 3571: pay_element_entries_f ele,

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

Line 3589: pay_element_entries_f ele,

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

Line 3704: FROM pay_element_entries_f ELE,

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

Line 3749: FROM pay_element_entries_f ELE,

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

Line 3777: FROM pay_element_entries_f ELE,

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

Line 3803: FROM pay_element_entries_f ELE,

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

Line 3839: FROM pay_element_entries_f ELE,

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

Line 3865: FROM pay_element_entries_f ELE,

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

Line 3990: pay_element_entries_f ELE,

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

Line 4019: pay_element_entries_f ELE,

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

Line 4037: pay_element_entries_f ELE,

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