DBA Data[Home] [Help]

APPS.HR_ES_UTILITY dependencies on PAY_ELEMENT_ENTRY_VALUES

Line 715: ,pay_element_entry_values_f peevf

711:
712: CURSOR get_screen_entry_value is
713: select peevf.screen_entry_value
714: from pay_element_entries_f peef
715: ,pay_element_entry_values_f peevf
716: where peef.assignment_id=p_assignment_id
717: and peef.element_type_id=p_element_type_id
718: and peevf.input_Value_id=p_input_value_id
719: and peevf.ELEMENT_ENTRY_ID=peef.element_entry_id

Line 723: l_entry_value pay_element_entry_values.screen_entry_value%type;

719: and peevf.ELEMENT_ENTRY_ID=peef.element_entry_id
720: and p_effective_date between peef.effective_start_date and peef.effective_end_date
721: and p_effective_date between peevf.effective_start_date and peevf.effective_end_date;
722:
723: l_entry_value pay_element_entry_values.screen_entry_value%type;
724: BEGIN
725: OPEN get_screen_entry_value;
726: FETCH get_screen_entry_value INTO l_entry_value;
727: IF get_screen_entry_value%FOUND THEN