APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_ELEMENT_LINKS_F

Line 69: FROM pay_element_links_f links, per_all_assignments_f assign

65: input_val_rec6 input_val_csr%ROWTYPE;
66: --
67: CURSOR link_csr(p_element_type_id IN NUMBER) IS
68: SELECT links.element_link_id
69: FROM pay_element_links_f links, per_all_assignments_f assign
70: WHERE links.element_type_id = p_element_type_id
71: AND links.business_group_id=p_business_group_id
72: AND assign.assignment_id=p_assignment_id
73: AND (( links.payroll_id is not null

Line 211: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;

207: ,p_date IN per_all_assignments_f.effective_start_date%TYPE
208: ,p_element_name IN pay_element_types_f.ELEMENT_NAME%TYPE
209: ) RETURN NUMBER
210: IS
211: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
212: CURSOR csr_get_ele_type_id IS
213: SELECT element_type_id
214: FROM pay_element_types_f
215: WHERE

Line 222: FROM pay_element_links_f links, per_all_assignments_f assign

218:
219: Cursor csr_element_link_id(p_element_type_id NUMBER)
220: IS
221: SELECT links.element_link_id
222: FROM pay_element_links_f links, per_all_assignments_f assign
223: WHERE links.element_type_id = p_element_type_id
224: AND links.business_group_id= p_business_group_id
225: AND assign.assignment_id= p_assignment_id
226: AND (( links.payroll_id is not null