DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 7823: from pay_personal_payment_methods_f ppm

7819: ppm.org_payment_method_id,
7820: greatest(ppm.effective_start_date,p_validation_start_date)
7821: start_date,
7822: least(ppm.effective_end_date,p_validation_end_date) end_date
7823: from pay_personal_payment_methods_f ppm
7824: where ppm.assignment_id = p_assignment_id
7825: and ppm.effective_start_date <= p_validation_end_date
7826: and ppm.effective_end_date >= p_validation_start_date;
7827: --

Line 7870: from pay_personal_payment_methods_f ppm

7866: into no_opmu
7867: from sys.dual
7868: where exists
7869: (select null
7870: from pay_personal_payment_methods_f ppm
7871: where assignment_id = p_assignment_id
7872: and ppm.effective_end_date >= p_validation_start_date);
7873: exception
7874: when no_data_found then