APPS.ARP_ARXCOQIT dependencies on DUAL

Line 634: from dual;

630: p_days_late IN OUT NOCOPY number) IS
631: begin
632: select trunc(sysdate) - p_due_date
633: into p_days_late
634: from dual;
635: -- arp_standard.enable_debug;
636: EXCEPTION
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN

Line 723: from dual;

719: |Get the length in characters of the where clause as Step 1 |
720: +---------------------------------------------------------------*/
721: select length(l_in_where_clause)
722: into l_actual_length
723: from dual;
724:
725: l_by_clause_pos := 0;
726:
727: /*--------------------------------------------------------------------+

Line 732: from dual;

728: |Strip the 'order by' clause if it is present as part of where clause|
729: +--------------------------------------------------------------------*/
730: select instr(l_in_where_clause, 'order by')
731: into l_by_clause_pos
732: from dual;
733:
734: IF (l_by_clause_pos > 0) THEN
735: l_length := l_by_clause_pos -1;
736: ELSE

Line 743: FROM DUAL;

739: |Strip the 'group by clause' if it is present as part of where clause|
740: +--------------------------------------------------------------------*/
741: SELECT INSTR(l_in_where_clause, 'group by')
742: INTO l_by_clause_pos
743: FROM DUAL;
744:
745: IF (l_by_clause_pos > 0) THEN
746: l_length := l_by_clause_pos - 1;
747: ELSE

Line 767: from dual;

763: l_temp_cell := ' ';
764: ELSE
765: select substr(l_in_where_clause, l_ctr, 1)
766: into l_temp_cell
767: from dual;
768: END IF;
769:
770: /*----------------------------------------------------------------+
771: |Check for character literals - they use the de-limiter quote |

Line 884: FROM dual;

880: IF (l_by_clause_pos > 0) THEN
881:
882: SELECT SUBSTR(l_in_where_clause, l_by_clause_pos)
883: INTO l_balance_clause
884: FROM dual;
885:
886: l_actual_where_clause := l_actual_where_clause || l_balance_clause;
887:
888: END IF; --end if by clause pos greater than 0