APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_LIST_HEADERS_B

Line 866: From qp_list_headers_b a

862: FROM qp_qualifiers q
863: WHERE (q.list_header_id = p_from_list_header_id AND
864: q.qualifier_attribute <> p_attribute AND
865: Exists (Select Null
866: From qp_list_headers_b a
867: Where a.list_header_id = p_from_list_header_id
868: And a.list_type_code = 'PRL'
869: )
870: )

Line 875: EXISTS (select null from qp_list_headers_b a

871: OR
872: (q.qualifier_context = p_context AND
873: q.qualifier_attribute = p_attribute AND
874: q.qualifier_attr_value = TO_CHAR(p_from_list_header_id) AND
875: EXISTS (select null from qp_list_headers_b a
876: where a.list_header_id =q.list_header_id
877: And a.list_type_code = 'PRL')
878: );
879:

Line 1446: FROM qp_list_headers_b

1442: ORIG_SYSTEM_HEADER_REF,
1443: SHAREABLE_FLAG,
1444: SOLD_TO_ORG_ID,
1445: l_conc_request_id
1446: FROM qp_list_headers_b
1447: WHERE list_header_id = p_entity;
1448:
1449: --Insert the count of records from QP_ARCH_LIST_HEADERS_B into QP_ARCH_ROW_COUNTS
1450: g_count_header_b:=sql%rowcount;

Line 1492: FROM QP_LIST_HEADERS_B

1488: /** Following code inserts pricing entity header qualifier information **/
1489: BEGIN
1490: SELECT LIST_TYPE_CODE
1491: INTO l_list_type_code
1492: FROM QP_LIST_HEADERS_B
1493: WHERE LIST_HEADER_ID = p_entity;
1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN