APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on DUAL

Line 561: from dual;

557: --dbms_output.put_line('pr2.1'||K);
558:
559: select qp_list_headers_b_s.nextval
560: into new_price_list_id
561: from dual;
562:
563: --dbms_output.put_line('pr2.2'||K);
564:
565: --NAME_T(K) := 'QPNEW' || NAME_T(K);

Line 966: from dual

962: --ENH Upgrade BOAPI for orig_sys...ref RAVI
963: ,to_char(QP_QUALIFIERS_S.currval)
964: ,null
965: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)
966: from dual
967: WHERE NOT EXISTS ( select null
968: from qp_qualifiers
969: where qualifier_context = 'MODLIST'
970: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1032: from dual

1028: 'N',
1029: l_datatype,
1030: l_precedence,
1031: NULL
1032: from dual
1033: WHERE NOT EXISTS ( select null
1034: from qp_qualifiers
1035: where qualifier_context = 'MODLIST'
1036: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1765: from dual;

1761: and agr_types(K) = 'AGR') ) then
1762:
1763: select qp_list_lines_s.nextval
1764: into new_prc_list_line_id
1765: from dual;
1766:
1767: price_list_line_ids(K) := new_prc_list_line_id;
1768:
1769: