APPS.QP_BULK_VALIDATE dependencies on QP_LIST_HEADERS_TL

Line 1368: from qp_list_headers_tl

1364: --Checking for uniqueness of the Name in qp_list_headers.
1365: l_exist:=null;
1366: Begin
1367: Select 1 into l_exist
1368: from qp_list_headers_tl
1369: where name= p_header_rec.name(I)
1370: and list_header_id <>
1371: (select list_header_id From qp_list_headers_b
1372: -- ENH unod alcoa changes RAVI

Line 3045: FROM QP_LIST_HEADERS_TL

3041: qp_bulk_loader_pub.write_log( 'Secondary Price List read from qp_list_header');
3042: BEGIN
3043: SELECT to_char(list_header_id)
3044: INTO p_qualifier_rec.qualifier_attr_value(I)
3045: FROM QP_LIST_HEADERS_TL
3046: WHERE NAME = p_qualifier_rec.qualifier_attr_value_code(I)
3047: AND LANGUAGE = userenv('LANG');
3048: EXCEPTION
3049: WHEN NO_DATA_FOUND THEN

Line 5532: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht

5528: FROM QP_INTERFACE_LIST_HEADERS qpih
5529: WHERE qpih.request_id = p_request_id
5530: AND qpih.process_status_flag ='P' --is null
5531: AND qpih.interface_action_code IN ('INSERT')
5532: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht
5533: where qlht.name= qpih.name
5534: and qlht.language = qpih.language);
5535:
5536: qp_bulk_loader_pub.write_log('Count '||SQL%ROWCOUNT);