APPS.HR_PAYMENTS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 439: from pay_personal_payment_methods_f ppm

435: into dummy
436: from dual
437: where not exists(
438: select 1
439: from pay_personal_payment_methods_f ppm
440: where ppm.org_payment_method_id = opm_id
441: and ppm.effective_end_date > fnd_date.canonical_to_date(val_start_date));
442: --
443: if dummy = 1 then

Line 658: from pay_personal_payment_methods_f ppm

654: into duplicate
655: from sys.dual
656: where not exists(
657: select 1
658: from pay_personal_payment_methods_f ppm
659: where ppm.assignment_id = assignment
660: and ppm.priority = in_priority
661: and fnd_date.canonical_to_date(val_start_date) < ppm.effective_end_date
662: and fnd_date.canonical_to_date(val_end_date) > ppm.effective_start_date);