DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PAY_ELEMENT_LINKS_F

Line 390: pay_element_links_f ell,

386: p_asg_id ghr_pa_requests.employee_assignment_id%type)
387: IS
388: select ele.effective_end_date
389: from pay_element_types_f elt,
390: pay_element_links_f ell,
391: pay_element_entries_f ele
392: where p_pa_request_rec.effective_date between elt.effective_start_date and elt.effective_end_date
393: and p_pa_request_rec.effective_date between ell.effective_start_date and ell.effective_end_date
394: and p_pa_request_rec.effective_date between ele.effective_start_date and ele.effective_end_date