1098: ,paa2.effective_end_date effectiveto
1099: ,sck2.segment4 wagetaxdiscount
1100: FROM per_all_assignments_f paa1
1101: ,per_all_assignments_f paa2
1102: ,hr_soft_coding_keyflex sck1
1103: ,hr_soft_coding_keyflex sck2
1104: WHERE l_reporting_date > paa2.effective_start_date
1105: AND (
1106: (
1099: ,sck2.segment4 wagetaxdiscount
1100: FROM per_all_assignments_f paa1
1101: ,per_all_assignments_f paa2
1102: ,hr_soft_coding_keyflex sck1
1103: ,hr_soft_coding_keyflex sck2
1104: WHERE l_reporting_date > paa2.effective_start_date
1105: AND (
1106: (
1107: paa2.effective_start_date =