DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 6800: from pay_personal_payment_methods_f ppm

6796: ppm.org_payment_method_id,
6797: greatest(ppm.effective_start_date,p_validation_start_date)
6798: start_date,
6799: least(ppm.effective_end_date,p_validation_end_date) end_date
6800: from pay_personal_payment_methods_f ppm
6801: where ppm.assignment_id = p_assignment_id
6802: and ppm.effective_start_date <= p_validation_end_date
6803: and ppm.effective_end_date >= p_validation_start_date;
6804: --

Line 6847: from pay_personal_payment_methods_f ppm

6843: into no_opmu
6844: from sys.dual
6845: where exists
6846: (select null
6847: from pay_personal_payment_methods_f ppm
6848: where assignment_id = p_assignment_id
6849: and ppm.effective_end_date >= p_validation_start_date);
6850: exception
6851: when no_data_found then