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

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

Line 637: pay_element_entries_f pee,

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

Line 2591: FROM PAY_ELEMENT_ENTRIES_F ELE,

2587: -- ...
2588: --
2589: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2590: INTO v_ele_exists
2591: FROM PAY_ELEMENT_ENTRIES_F ELE,
2592: PAY_ELEMENT_LINKS_F ELI,
2593: PAY_ELEMENT_TYPES_F ELT
2594: WHERE p_date_earned
2595: BETWEEN ELE.effective_start_date

Line 2967: pay_element_entries_f ELE,

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

Line 2988: FROM pay_element_entries_f ELE,

2984: hr_utility.set_location('Other_Non_Separate_Check', 20);
2985:
2986: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
2987: INTO sepcheck_flag
2988: FROM pay_element_entries_f ELE,
2989: pay_element_links_f ELL,
2990: pay_element_types_f ELT,
2991: pay_element_classifications ECL
2992: WHERE ELE.assignment_id = p_ass_id

Line 3143: pay_element_entries_f ELE,

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

Line 3159: FROM pay_element_entries_f ELE,

3155: CURSOR get_include_in_ot IS
3156: SELECT ELT.element_type_id,
3157: ELT.element_name,
3158: FRA.formula_name
3159: FROM pay_element_entries_f ELE,
3160: pay_element_links_f ELI,
3161: pay_element_types_f ELT,
3162: pay_status_processing_rules_f SPR,
3163: ff_formulas_f FRA

Line 3194: pay_element_entries_f ele,

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

Line 3213: pay_element_entries_f ele,

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

Line 3231: pay_element_entries_f ele,

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

Line 3337: pay_element_entries_f ELE,

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

Line 3376: pay_element_entries_f ELE,

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

Line 3394: pay_element_entries_f ELE,

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

Line 3410: pay_element_entries_f ELE,

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

Line 3438: pay_element_entries_f ELE,

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

Line 3454: pay_element_entries_f ELE,

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

Line 3576: pay_element_entries_f ELE,

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

Line 3606: pay_element_entries_f ELE,

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

Line 3625: pay_element_entries_f ELE,

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

Line 4343: ,pay_element_entries_f pee

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