APPS.IGS_AS_PROD_DOC dependencies on FND_DATE

Line 559: WHERE fnd_date.date_to_canonical(aoii.date_produced) = cp_date_produced

555: SELECT aoii.order_number order_number,
556: aoii.item_number item_number,
557: aoii.person_id person_id
558: FROM igs_as_ord_itm_int aoii
559: WHERE fnd_date.date_to_canonical(aoii.date_produced) = cp_date_produced
560: AND aoii.item_status = 'PROCESSED';
561: --
562: -- Cursor to get the oracle applications user_name corresponding to the person_id
563: --