DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMIT_ATTRS dependencies on QP_LIST_HEADERS_B

Line 21: SELECT list_type_code into l_list_type_code from QP_LIST_HEADERS_B

17: l_return_status VARCHAR2(1);
18: BEGIN
19:
20:
21: SELECT list_type_code into l_list_type_code from QP_LIST_HEADERS_B
22: WHERE LIST_HEADER_ID = p_LIMITS_rec.list_header_id;
23:
24: IF (l_list_type_code IN ('DLT','SLT','DEL','PRO'))
25: THEN

Line 857: FROM qp_list_headers_b

853: BEGIN
854:
855: SELECT pte_code, source_system_code
856: INTO l_pte_code, l_ss_code
857: FROM qp_list_headers_b
858: WHERE list_header_id = l_LIMITS_rec.list_header_id;
859:
860: QP_UTIL.Get_Item_Cat_Info(
861: l_LIMIT_ATTRS_rec.limit_attr_value,