APPS.PAY_IE_MEDICAL_ADJUST dependencies on PAY_ELEMENT_LINKS_F

Line 41: FROM pay_element_links_f links, per_all_assignments_f assign

37: input_val_rec1 input_val_csr%ROWTYPE;
38: --
39: CURSOR link_csr(p_element_type_id IN NUMBER) IS
40: SELECT links.element_link_id
41: FROM pay_element_links_f links, per_all_assignments_f assign
42: WHERE links.element_type_id = p_element_type_id
43: AND links.business_group_id=p_bg_id
44: AND assign.assignment_id=p_asg_id
45: AND (( links.payroll_id is not null