952: ,paa.effective_start_date
953: ,paa.effective_end_date
954: ,scl.segment2
955: FROM per_all_assignments_f paa
956: ,hr_soft_coding_keyflex scl
957: WHERE person_id = csr_v_person_id
958: AND paa.effective_start_date <= g_income_end_date
959: AND paa.effective_end_date > = g_income_start_date
960: AND paa.primary_flag = 'Y'
2000: IS
2001: SELECT MIN (paa.effective_start_date) effective_start_date
2002: ,MAX (paa.effective_end_date) effective_end_date
2003: FROM per_all_assignments_f paa
2004: ,hr_soft_coding_keyflex scl
2005: WHERE person_id = csr_v_person_id
2006: AND paa.effective_start_date <= g_income_end_date
2007: AND paa.effective_end_date > = g_income_start_date
2008: AND assignment_status_type_id IN (
2051: IS
2052: SELECT scl.segment2
2053: ,scl.segment8
2054: FROM per_all_assignments_f paa
2055: ,hr_soft_coding_keyflex scl
2056: ,pay_assignment_actions pasa
2057: WHERE pasa.assignment_action_id = p_assignment_action_id
2058: AND pasa.assignment_id = paa.assignment_id
2059: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2111: ,paa.effective_start_date
2112: ,paa.effective_end_date
2113: ,scl.segment2
2114: FROM per_all_assignments_f paa
2115: ,hr_soft_coding_keyflex scl
2116: WHERE paa.person_id = csr_v_person_id
2117: AND paa.effective_start_date <= g_income_end_date
2118: AND paa.effective_end_date > = g_income_start_date
2119: AND paa.assignment_status_type_id IN (
2136: ,paa.effective_start_date
2137: ,paa.effective_end_date
2138: ,scl.segment2
2139: FROM per_all_assignments_f paa
2140: ,hr_soft_coding_keyflex scl
2141: WHERE person_id = csr_v_person_id
2142: AND paa.effective_start_date <= g_income_end_date
2143: AND paa.effective_end_date > = g_income_start_date
2144: AND paa.primary_flag = 'Y'