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.PAY_CORE_FF_UDFS dependencies on PAY_ELEMENT_ENTRIES_F

Line 348: FROM pay_element_entries_f peef

344: CURSOR get_RegSal_ele_entry_id(cp_leg_code IN VARCHAR2
345: ,cp_assignment_id IN NUMBER
346: ,cp_effective_date IN DATE) IS
347: SELECT peef.element_entry_id
348: FROM pay_element_entries_f peef
349: ,pay_element_types_f pet
350: where peef.element_type_id = pet.element_type_id
351: and peef.assignment_id = cp_assignment_id
352: and pet.element_name = 'Regular Salary'

Line 373: FROM pay_element_entries_f peef

369: CURSOR get_earning_xtra_ele_info(cp_element_entry_id IN NUMBER
370: ,cp_assignment_id IN NUMBER
371: ,cp_bg_id IN NUMBER) IS
372: SELECT petei.eei_information10
373: FROM pay_element_entries_f peef
374: ,pay_element_types_f pet
375: ,pay_element_type_extra_info petei
376: where peef.element_entry_id = cp_element_entry_id
377: and peef.assignment_id = cp_assignment_id

Line 393: FROM pay_element_entries_f peef

389: ,cp_leg_code IN VARCHAR2) IS
390: SELECT pet.business_group_id
391: ,pet.legislation_code
392: ,pec.classification_name
393: FROM pay_element_entries_f peef
394: ,pay_element_types_f pet
395: ,pay_element_classifications pec
396: WHERE peef.element_entry_id = cp_element_entry_id
397: and peef.assignment_id = cp_assignment_id

Line 1615: pay_element_entries_f pee,

1611: CURSOR get_vac_hours ( v_asg_id NUMBER,
1612: v_eff_date DATE) IS
1613: select fnd_number.canonical_to_number(pev.screen_entry_value)
1614: from per_absence_attendance_types abt,
1615: pay_element_entries_f pee,
1616: pay_element_entry_values_f pev
1617: where pev.input_value_id = abt.input_value_id
1618: and abt.absence_category = 'V'
1619: and v_eff_date between pev.effective_start_date

Line 1681: pay_element_entries_f pee,

1677: CURSOR get_sick_hours ( v_asg_id NUMBER,
1678: v_eff_date DATE) IS
1679: select fnd_number.canonical_to_number(pev.screen_entry_value)
1680: from per_absence_attendance_types abt,
1681: pay_element_entries_f pee,
1682: pay_element_entry_values_f pev
1683: where pev.input_value_id = abt.input_value_id
1684: and abt.absence_category = 'S'
1685: and v_eff_date between pev.effective_start_date

Line 3088: from pay_element_entries_f EE

3084: CURSOR get_salary (l_date_earned date,
3085: l_assignment_id number,
3086: l_input_value_id number) IS
3087: select fnd_number.canonical_to_number (EEV.screen_entry_value)
3088: from pay_element_entries_f EE
3089: , pay_element_entry_values_f EEV
3090: where EEV.input_value_id = l_input_value_id
3091: and l_date_earned BETWEEN EEV.effective_start_date
3092: AND EEV.effective_end_date

Line 4147: pay_element_entries_f pee,

4143: CURSOR get_sick_hours ( v_asg_id NUMBER,
4144: v_eff_date DATE) IS
4145: select fnd_number.canonical_to_number(pev.screen_entry_value)
4146: from per_absence_attendance_types abt,
4147: pay_element_entries_f pee,
4148: pay_element_entry_values_f pev
4149: where pev.input_value_id = abt.input_value_id
4150: and abt.absence_category = 'S'
4151: and v_eff_date between pev.effective_start_date

Line 4169: ,pay_element_entries_f pee

4165: ,abs.date_end
4166: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4167: from per_absence_attendance_types abt
4168: ,per_absence_attendances abs
4169: ,pay_element_entries_f pee
4170: ,pay_element_entry_values_f peev
4171: where abt.input_value_id = peev.input_value_id
4172: and abt.absence_category = 'S'
4173: and abt.absence_attendance_type_id = abs.absence_attendance_type_id

Line 4182: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;

4178: and pee.assignment_id = v_asg_id
4179: and v_eff_date between peev.effective_start_date and peev.effective_end_date
4180: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4181:
4182: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4183: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4184: ld_start_date per_absence_attendances.date_start%TYPE;
4185: ld_end_date per_absence_attendances.date_end%TYPE;
4186:

Line 4280: pay_element_entries_f pee,

4276: CURSOR get_vac_hours ( v_asg_id NUMBER,
4277: v_eff_date DATE) IS
4278: select fnd_number.canonical_to_number(pev.screen_entry_value)
4279: from per_absence_attendance_types abt,
4280: pay_element_entries_f pee,
4281: pay_element_entry_values_f pev
4282: where pev.input_value_id = abt.input_value_id
4283: and abt.absence_category = 'V'
4284: and v_eff_date between pev.effective_start_date

Line 4302: ,pay_element_entries_f pee

4298: ,abs.date_end
4299: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4300: from per_absence_attendance_types abt
4301: ,per_absence_attendances abs
4302: ,pay_element_entries_f pee
4303: ,pay_element_entry_values_f peev
4304: where abt.input_value_id = peev.input_value_id
4305: and abt.absence_category = 'V'
4306: and abt.absence_attendance_type_id = abs.absence_attendance_type_id

Line 4315: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;

4311: and pee.assignment_id = v_asg_id
4312: and v_eff_date between peev.effective_start_date and peev.effective_end_date
4313: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4314:
4315: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4316: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4317: ld_start_date per_absence_attendances.date_start%TYPE;
4318: ld_end_date per_absence_attendances.date_end%TYPE;
4319: