DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_ELEMENT_ENTRIES_F

Line 1236: pay_element_entries_f pee,

1232: CURSOR get_vac_hours ( v_asg_id NUMBER,
1233: v_eff_date DATE) IS
1234: select fnd_number.canonical_to_number(pev.screen_entry_value)
1235: from per_absence_attendance_types abt,
1236: pay_element_entries_f pee,
1237: pay_element_entry_values_f pev
1238: where pev.input_value_id = abt.input_value_id
1239: and abt.absence_category = 'V'
1240: and v_eff_date between pev.effective_start_date

Line 1302: pay_element_entries_f pee,

1298: CURSOR get_sick_hours ( v_asg_id NUMBER,
1299: v_eff_date DATE) IS
1300: select fnd_number.canonical_to_number(pev.screen_entry_value)
1301: from per_absence_attendance_types abt,
1302: pay_element_entries_f pee,
1303: pay_element_entry_values_f pev
1304: where pev.input_value_id = abt.input_value_id
1305: and abt.absence_category = 'S'
1306: and v_eff_date between pev.effective_start_date

Line 2679: from pay_element_entries_f EE

2675: CURSOR get_salary (l_date_earned date,
2676: l_assignment_id number,
2677: l_input_value_id number) IS
2678: select fnd_number.canonical_to_number (EEV.screen_entry_value)
2679: from pay_element_entries_f EE
2680: , pay_element_entry_values_f EEV
2681: where EEV.input_value_id = l_input_value_id
2682: and l_date_earned BETWEEN EEV.effective_start_date
2683: AND EEV.effective_end_date