APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_LIST_HEADERS_B

Line 845: From qp_list_headers_b a

841: FROM qp_qualifiers q
842: WHERE (q.list_header_id = p_from_list_header_id AND
843: q.qualifier_attribute <> p_attribute AND
844: Exists (Select Null
845: From qp_list_headers_b a
846: Where a.list_header_id = p_from_list_header_id
847: And a.list_type_code = 'PRL'
848: )
849: )

Line 854: EXISTS (select null from qp_list_headers_b a

850: OR
851: (q.qualifier_context = p_context AND
852: q.qualifier_attribute = p_attribute AND
853: q.qualifier_attr_value = TO_CHAR(p_from_list_header_id) AND
854: EXISTS (select null from qp_list_headers_b a
855: where a.list_header_id =q.list_header_id
856: And a.list_type_code = 'PRL')
857: );
858:

Line 1380: FROM qp_list_headers_b

1376: ORIG_SYSTEM_HEADER_REF,
1377: SHAREABLE_FLAG,
1378: SOLD_TO_ORG_ID,
1379: l_conc_request_id
1380: FROM qp_list_headers_b
1381: WHERE list_header_id = p_entity;
1382:
1383: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS
1384: g_count_header_b:=sql%rowcount;

Line 1426: FROM QP_LIST_HEADERS_B

1422: /** Following code inserts pricing entity header qualifier information **/
1423: BEGIN
1424: SELECT LIST_TYPE_CODE
1425: INTO l_list_type_code
1426: FROM QP_LIST_HEADERS_B
1427: WHERE LIST_HEADER_ID = p_entity;
1428:
1429: EXCEPTION
1430: WHEN OTHERS THEN