DBA Data[Home] [Help]

APPS.QP_DEFAULT_PRICE_LIST dependencies on DUAL

Line 159: from dual;

155:
156: oe_debug_pub.add('Entering QP_Default_Price_List.Get_Price_List');
157:
158: select qp_list_headers_b_s.nextval into l_list_header_id
159: from dual;
160:
161: oe_debug_pub.add('Exiting QP_Default_Price_List.Get_Price_List');
162: RETURN l_list_header_id;
163:

Line 256: FROM dual;

252: begin
253: -- Get next currency_header_id
254: SELECT QP_CURRENCY_LISTS_B_S.NEXTVAL
255: INTO ll_currency_header_id
256: FROM dual;
257:
258: -- Insert one record into qp_currency_lists
259: INSERT INTO QP_CURRENCY_LISTS_B
260: ( ATTRIBUTE1

Line 529: FROM DUAL;

525:
526: oe_debug_pub.add('entering start date active');
527: SELECT TRUNC(SYSDATE)
528: INTO l_sysdate
529: FROM DUAL;
530:
531: oe_debug_pub.add('exiting start date active');
532:
533: RETURN l_sysdate;