2255: INDEX(NROLL PAY_PAYROLLS_F_PK)
2256: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2257: nvl(max(ASS.effective_start_date),
2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2256: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2257: nvl(max(ASS.effective_start_date),
2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2264: ,hr_soft_coding_keyflex PFLEX