2225: --
2226: cursor personal_payment_method is
2227: select min (ppm1.effective_start_date),
2228: max (ppm2.effective_end_date)
2229: from pay_personal_payment_methods_f PPM1,
2230: pay_personal_payment_methods_f PPM2
2231: where ppm1.personal_payment_method_id = p_personal_payment_method_id
2232: and ppm2.personal_payment_method_id = p_personal_payment_method_id
2233: and ppm1.assignment_id = p_assignment_id;
2226: cursor personal_payment_method is
2227: select min (ppm1.effective_start_date),
2228: max (ppm2.effective_end_date)
2229: from pay_personal_payment_methods_f PPM1,
2230: pay_personal_payment_methods_f PPM2
2231: where ppm1.personal_payment_method_id = p_personal_payment_method_id
2232: and ppm2.personal_payment_method_id = p_personal_payment_method_id
2233: and ppm1.assignment_id = p_assignment_id;
2234: --