DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on FND_DATE

Line 655: l_receipt_date_low := fnd_date.canonical_to_date(p_receipt_date_l);

651: l_where_clause := l_where_clause || ' AND ps.amount_due_remaining * -1 >= :b_min_unapp_amt
652: AND ps.cash_receipt_id = ref.cash_receipt_id ';
653: END IF;
654: IF p_receipt_date_l IS NOT NULL THEN
655: l_receipt_date_low := fnd_date.canonical_to_date(p_receipt_date_l);
656: l_where_clause := l_where_clause || ' AND cr.receipt_date >= :b_receipt_date_l ';
657: END IF;
658: IF p_receipt_date_h IS NOT NULL THEN
659: l_receipt_date_high := fnd_date.canonical_to_date(p_receipt_date_h);

Line 659: l_receipt_date_high := fnd_date.canonical_to_date(p_receipt_date_h);

655: l_receipt_date_low := fnd_date.canonical_to_date(p_receipt_date_l);
656: l_where_clause := l_where_clause || ' AND cr.receipt_date >= :b_receipt_date_l ';
657: END IF;
658: IF p_receipt_date_h IS NOT NULL THEN
659: l_receipt_date_high := fnd_date.canonical_to_date(p_receipt_date_h);
660: l_where_clause := l_where_clause || ' AND cr.receipt_date <= :b_receipt_date_h ';
661: END IF;
662: IF p_receipt_method_l IS NOT NULL THEN
663: l_where_clause := l_where_clause || ' AND rm.name >= :b_receipt_method_l ';