DBA Data[Home] [Help]

APPS.QP_BULK_LOADER_PUB dependencies on DUAL

Line 282: FROM dual

278: INTO l_min_list_line_id, l_max_list_line_id
279: FROM qp_list_lines
280: WHERE list_header_id = l_lst_hdr_rec.list_header_id
281: AND REQUEST_ID IN (SELECT l_request_id
282: FROM dual
283: UNION
284: SELECT request_id
285: FROM FND_CONCURRENT_REQUESTS
286: WHERE parent_request_id = l_request_id

Line 335: FROM dual

331: INTO l_min_list_line_id, l_max_list_line_id
332: FROM qp_list_lines
333: WHERE list_header_id = l_lst_hdr_rec.list_header_id
334: AND REQUEST_ID IN (SELECT l_request_id
335: FROM dual
336: UNION
337: SELECT request_id
338: FROM FND_CONCURRENT_REQUESTS
339: WHERE parent_request_id = l_request_id

Line 6088: from dual;

6084: and orig_sys_line_ref = G_INS_LINE_REC.price_break_header_ref(I);
6085:
6086: select QP_RLTD_MODIFIERS_S.nextval
6087: into l_rltd_modifiers_id
6088: from dual;
6089:
6090: SELECT QP_RLTD_MODIFIER_GRP_NO_S.nextval
6091: INTO l_rltd_modifiers_grp_no
6092: FROM dual;

Line 6092: FROM dual;

6088: from dual;
6089:
6090: SELECT QP_RLTD_MODIFIER_GRP_NO_S.nextval
6091: INTO l_rltd_modifiers_grp_no
6092: FROM dual;
6093:
6094:
6095: QP_RLTD_MODIFIER_PVT.Insert_Row(
6096: l_rltd_modifiers_id