DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_ELEMENT_ENTRIES_F

Line 2923: FROM pay_element_entries_f

2919:
2920: CURSOR csr_get_element (csr_v_element_type_id NUMBER)
2921: IS
2922: SELECT effective_start_date
2923: FROM pay_element_entries_f
2924: WHERE assignment_id = p_assignment_id
2925: AND element_type_id = csr_v_element_type_id
2926: AND effective_start_date BETWEEN g_start_date AND g_end_date;
2927:

Line 3108: FROM pay_element_entries_f peef

3104: )
3105: IS
3106: SELECT peef.effective_start_date
3107: ,peevf.screen_entry_value
3108: FROM pay_element_entries_f peef
3109: ,pay_element_entry_values_f peevf
3110: WHERE peef.assignment_id = p_assignment_id
3111: AND peef.element_type_id = csr_v_element_type_id
3112: AND peef.effective_start_date BETWEEN g_start_date AND g_end_date