APPS.PAY_IE_PAYE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 62: FROM pay_element_links_f links, per_all_assignments_f assign

58: --
59:
60: CURSOR link_csr(p_element_type_id IN NUMBER) IS
61: SELECT links.element_link_id
62: FROM pay_element_links_f links, per_all_assignments_f assign
63: WHERE links.element_type_id = p_element_type_id
64: AND links.business_group_id=p_business_group_id
65: AND assign.assignment_id=p_assignment_id
66: AND (( links.payroll_id is not null

Line 573: FROM pay_element_links_f links, per_all_assignments_f assign

569: --
570: -- BUG 2616218
571: CURSOR link_csr(p_element_type_id IN NUMBER) IS
572: SELECT links.element_link_id
573: FROM pay_element_links_f links, per_all_assignments_f assign
574: WHERE links.element_type_id = p_element_type_id
575: AND links.business_group_id=p_business_group_id
576: AND assign.assignment_id=p_assignment_id
577: AND (( links.payroll_id is not null

Line 833: FROM per_all_assignments_f

829: l_business_group_id number;
830: --
831: CURSOR business_group_csr IS
832: SELECT business_group_id
833: FROM per_all_assignments_f
834: WHERE assignment_id = p_assignment_id
835: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
836: --
837: --

Line 1302: FROM per_all_assignments_f

1298: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1299: --
1300: CURSOR business_group_csr IS
1301: SELECT business_group_id
1302: FROM per_all_assignments_f
1303: WHERE assignment_id = l_assignment_id
1304: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1305:
1306: --6015209

Line 1838: FROM per_all_assignments_f

1834: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1835: --
1836: CURSOR business_group_csr IS
1837: SELECT business_group_id
1838: FROM per_all_assignments_f
1839: WHERE assignment_id = l_assignment_id
1840: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1841: --
1842: l_object_version_p45p3 NUMBER;