792: IS
793: select pee.effective_start_date effective_start_date
794: , pee.effective_end_date effective_end_date
795: , pee.element_entry_id element_entry_id
796: from pay_element_entries_f pee
797: where pee.element_link_id = p_element_link_id;
798:
799: ------------
800: -- Variables
928: select prr.ASSIGNMENT_ACTION_ID
929: ,prr.ELEMENT_ENTRY_ID
930: ,peef.ASSIGNMENT_ID
931: from pay_run_results prr
932: ,pay_element_entries_f peef
933: where prr.element_entry_id = peef.element_entry_id
934: and prr.run_result_id = p_run_result_id;
935:
936: cur_run_res_con_rec cur_run_res_con%ROWTYPE;