DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PAY_ELEMENT_LINKS_F

Line 334: pay_element_links_f ell,

330: p_asg_id ghr_pa_requests.employee_assignment_id%type)
331: IS
332: select ele.effective_end_date
333: from pay_element_types_f elt,
334: pay_element_links_f ell,
335: pay_element_entries_f ele
336: where p_pa_request_rec.effective_date between elt.effective_start_date and elt.effective_end_date
337: and p_pa_request_rec.effective_date between ell.effective_start_date and ell.effective_end_date
338: and p_pa_request_rec.effective_date between ele.effective_start_date and ele.effective_end_date