APPS.ARP_ARXCOQIT dependencies on DUAL

Line 627: from dual;

623: p_days_late IN OUT NOCOPY number) IS
624: begin
625: select trunc(sysdate) - p_due_date
626: into p_days_late
627: from dual;
628: -- arp_standard.enable_debug;
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF PG_DEBUG in ('Y', 'C') THEN

Line 716: from dual;

712: |Get the length in characters of the where clause as Step 1 |
713: +---------------------------------------------------------------*/
714: select length(l_in_where_clause)
715: into l_actual_length
716: from dual;
717:
718: l_by_clause_pos := 0;
719:
720: /*--------------------------------------------------------------------+

Line 725: from dual;

721: |Strip the 'order by' clause if it is present as part of where clause|
722: +--------------------------------------------------------------------*/
723: select instr(l_in_where_clause, 'order by')
724: into l_by_clause_pos
725: from dual;
726:
727: IF (l_by_clause_pos > 0) THEN
728: l_length := l_by_clause_pos -1;
729: ELSE

Line 736: FROM DUAL;

732: |Strip the 'group by clause' if it is present as part of where clause|
733: +--------------------------------------------------------------------*/
734: SELECT INSTR(l_in_where_clause, 'group by')
735: INTO l_by_clause_pos
736: FROM DUAL;
737:
738: IF (l_by_clause_pos > 0) THEN
739: l_length := l_by_clause_pos - 1;
740: ELSE

Line 760: from dual;

756: l_temp_cell := ' ';
757: ELSE
758: select substr(l_in_where_clause, l_ctr, 1)
759: into l_temp_cell
760: from dual;
761: END IF;
762:
763: /*----------------------------------------------------------------+
764: |Check for character literals - they use the de-limiter quote |

Line 877: FROM dual;

873: IF (l_by_clause_pos > 0) THEN
874:
875: SELECT SUBSTR(l_in_where_clause, l_by_clause_pos)
876: INTO l_balance_clause
877: FROM dual;
878:
879: l_actual_where_clause := l_actual_where_clause || l_balance_clause;
880:
881: END IF; --end if by clause pos greater than 0