DBA Data[Home] [Help]

APPS.PAY_PAYMENT_METHODS_PKG dependencies on FND_DATE

Line 417: l_after_this_date := fnd_date.date_to_canonical(p_after_this_date);

413: close el_ent_check;
414: END IF;
415: END IF;
416: --
417: l_after_this_date := fnd_date.date_to_canonical(p_after_this_date);
418: --
419: IF hr_payments.check_pp (to_char (P_PPM_ID), l_after_this_date) THEN
420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
421: WHERE ROWID = P_ROWID;

Line 790: and fnd_date.canonical_to_date(p_new_date) between effective_start_date

786: cursor payroll_on_new_date is
787: select payroll_id
788: from per_all_assignments_f
789: where assignment_id = to_number (p_asg_id)
790: and fnd_date.canonical_to_date(p_new_date) between effective_start_date
791: and effective_end_date;
792: --
793: begin
794: open payroll_on_new_date;