APPS.GL_BC_PACKETS_PKG dependencies on DUAL

Line 108: FROM dual;

104:
105: FUNCTION get_unique_id RETURN NUMBER IS
106: CURSOR get_new_id IS
107: SELECT gl_bc_packets_s.NEXTVAL
108: FROM dual;
109: new_id number;
110: BEGIN
111: OPEN get_new_id;
112: FETCH get_new_id INTO new_id;

Line 195: FROM dual

191:
192: FUNCTION exists_packet(xpacket_id NUMBER) RETURN BOOLEAN IS
193: CURSOR check_for_pkt IS
194: SELECT 'Has packet'
195: FROM dual
196: WHERE EXISTS (SELECT 'Has packet'
197: FROM gl_bc_packets
198: WHERE packet_id = xpacket_id);
199: dummy VARCHAR2(100);

Line 639: FROM dual;

635: INSERT INTO PSA_BC_REPORT_EVENTS_GT(packet_id) VALUES (packet_id);
636:
637: SELECT PSA_BC_XML_REPORT_S.nextval
638: INTO seq_id
639: FROM dual;
640:
641: PSA_BC_XML_REPORT_PUB.Create_BC_Transaction_Report(
642: errbuf => errbuf,
643: retcode => retcode,