53: --
54:
55: CURSOR link_csr(p_element_type_id IN NUMBER) IS
56: SELECT links.element_link_id
57: FROM pay_element_links_f links, per_all_assignments_f assign
58: WHERE links.element_type_id = p_element_type_id
59: AND links.business_group_id=p_business_group_id
60: AND assign.assignment_id=p_assignment_id
61: AND (( links.payroll_id is not null
495: --
496: -- BUG 2616218
497: CURSOR link_csr(p_element_type_id IN NUMBER) IS
498: SELECT links.element_link_id
499: FROM pay_element_links_f links, per_all_assignments_f assign
500: WHERE links.element_type_id = p_element_type_id
501: AND links.business_group_id=p_business_group_id
502: AND assign.assignment_id=p_assignment_id
503: AND (( links.payroll_id is not null
693: l_business_group_id number;
694: --
695: CURSOR business_group_csr IS
696: SELECT business_group_id
697: FROM per_all_assignments_f
698: WHERE assignment_id = p_assignment_id
699: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
700: --
701: --
986: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
987: --
988: CURSOR business_group_csr IS
989: SELECT business_group_id
990: FROM per_all_assignments_f
991: WHERE assignment_id = l_assignment_id
992: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
993:
994: --6015209
1371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1372: --
1373: CURSOR business_group_csr IS
1374: SELECT business_group_id
1375: FROM per_all_assignments_f
1376: WHERE assignment_id = l_assignment_id
1377: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1378: --
1379: l_object_version_p45p3 NUMBER;