DBA Data[Home] [Help]

APPS.HR_ES_UTILITY dependencies on PAY_ELEMENT_ENTRY_VALUES

Line 795: ,pay_element_entry_values_f peevf

791:
792: CURSOR get_screen_entry_value is
793: select peevf.screen_entry_value
794: from pay_element_entries_f peef
795: ,pay_element_entry_values_f peevf
796: where peef.assignment_id=p_assignment_id
797: and peef.element_type_id=p_element_type_id
798: and peevf.input_Value_id=p_input_value_id
799: and peevf.ELEMENT_ENTRY_ID=peef.element_entry_id

Line 803: l_entry_value pay_element_entry_values.screen_entry_value%type;

799: and peevf.ELEMENT_ENTRY_ID=peef.element_entry_id
800: and p_effective_date between peef.effective_start_date and peef.effective_end_date
801: and p_effective_date between peevf.effective_start_date and peevf.effective_end_date;
802:
803: l_entry_value pay_element_entry_values.screen_entry_value%type;
804: BEGIN
805: OPEN get_screen_entry_value;
806: FETCH get_screen_entry_value INTO l_entry_value;
807: IF get_screen_entry_value%FOUND THEN