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_ENTRIES_F

Line 587: pay_element_entries_f pee,

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

Line 643: pay_element_entries_f pee,

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

Line 2628: FROM PAY_ELEMENT_ENTRIES_F ELE,

2624: -- ...
2625: --
2626: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2627: INTO v_ele_exists
2628: FROM PAY_ELEMENT_ENTRIES_F ELE,
2629: PAY_ELEMENT_LINKS_F ELI,
2630: PAY_ELEMENT_TYPES_F ELT
2631: WHERE p_date_earned
2632: BETWEEN ELE.effective_start_date

Line 3004: pay_element_entries_f ELE,

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
3008: BETWEEN ELE.effective_start_date AND ELE.effective_end_date

Line 3025: FROM pay_element_entries_f ELE,

3021: hr_utility.set_location('Other_Non_Separate_Check', 20);
3022:
3023: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3024: INTO sepcheck_flag
3025: FROM pay_element_entries_f ELE,
3026: pay_element_links_f ELL,
3027: pay_element_types_f ELT,
3028: pay_element_classifications ECL
3029: WHERE ELE.assignment_id = p_ass_id

Line 3180: pay_element_entries_f ELE,

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
3184: AND p_date_earned

Line 3196: FROM pay_element_entries_f ELE,

3192: CURSOR get_include_in_ot IS
3193: SELECT ELT.element_type_id,
3194: ELT.element_name,
3195: FRA.formula_name
3196: FROM pay_element_entries_f ELE,
3197: pay_element_links_f ELI,
3198: pay_element_types_f ELT,
3199: pay_status_processing_rules_f SPR,
3200: ff_formulas_f FRA

Line 3231: pay_element_entries_f ele,

3227: */
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

Line 3250: pay_element_entries_f ele,

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

Line 3268: pay_element_entries_f ele,

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

Line 3374: pay_element_entries_f ELE,

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

Line 3413: pay_element_entries_f ELE,

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
3417: AND p_date_earned

Line 3431: pay_element_entries_f ELE,

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
3435: AND p_date_earned

Line 3447: pay_element_entries_f ELE,

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

Line 3475: pay_element_entries_f ELE,

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
3479: AND p_date_earned

Line 3491: pay_element_entries_f ELE,

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
3495: AND p_date_earned

Line 3613: pay_element_entries_f ELE,

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

Line 3643: pay_element_entries_f ELE,

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

Line 3662: pay_element_entries_f ELE,

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

Line 4380: ,pay_element_entries_f pee

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
4384: ,per_pay_bases ppb