APPS.QP_BULK_VALIDATE dependencies on QP_LIST_HEADERS_TL

Line 1524: from qp_list_headers_tl

1520: --Checking for uniqueness of the Name in qp_list_headers.
1521: l_exist:=null;
1522: Begin
1523: Select 1 into l_exist
1524: from qp_list_headers_tl
1525: where name= p_header_rec.name(I)
1526: and list_header_id <>
1527: (select list_header_id From qp_list_headers_b
1528: -- ENH unod alcoa changes RAVI

Line 3172: FROM QP_LIST_HEADERS_TL

3168: qp_bulk_loader_pub.write_log( 'Secondary Price List read from qp_list_header');
3169: BEGIN
3170: SELECT to_char(list_header_id)
3171: INTO p_qualifier_rec.qualifier_attr_value(I)
3172: FROM QP_LIST_HEADERS_TL
3173: WHERE NAME = p_qualifier_rec.qualifier_attr_value_code(I)
3174: AND LANGUAGE = userenv('LANG');
3175: EXCEPTION
3176: WHEN NO_DATA_FOUND THEN

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

5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5541: WHERE qpih.request_id = p_request_id
5542: AND qpih.process_status_flag ='P' --is null
5543: AND qpih.interface_action_code IN ('INSERT')
5544: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht
5545: where qlht.name= qpih.name
5546: and qlht.language = qpih.language);
5547:
5548: qp_bulk_loader_pub.write_log('Count '||SQL%ROWCOUNT);