DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_ELEMENT_ENTRIES_F

Line 3370: FROM pay_element_entries_f

3366:
3367: CURSOR csr_get_element (csr_v_element_type_id NUMBER)
3368: IS
3369: SELECT effective_start_date
3370: FROM pay_element_entries_f
3371: WHERE assignment_id = p_assignment_id
3372: AND element_type_id = csr_v_element_type_id
3373: AND effective_start_date BETWEEN g_start_date AND g_end_date;
3374:

Line 3555: FROM pay_element_entries_f peef

3551: )
3552: IS
3553: SELECT peef.effective_start_date
3554: ,peevf.screen_entry_value
3555: FROM pay_element_entries_f peef
3556: ,pay_element_entry_values_f peevf
3557: WHERE peef.assignment_id = p_assignment_id
3558: AND peef.element_type_id = csr_v_element_type_id
3559: AND peef.effective_start_date BETWEEN g_start_date AND g_end_date