753:
754:
755: CURSOR list_hdr_id(p_currency_code VARCHAR2) IS
756: SELECT QH.LIST_HEADER_ID
757: FROM QP_LIST_HEADERS_B QH
758: WHERE QH.LIST_TYPE_CODE = 'PRL'
759: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
760: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE
761: AND QH.mobile_download = 'Y'
824: l_currency_code
825: FROM QP_PRICING_ATTRIBUTES QPA,
826: QP_LIST_LINES QL,
827: ASL_INVENTORY_ITEM_DENORM ITEM ,
828: QP_LIST_HEADERS_B QH
829: WHERE QPA.LIST_HEADER_ID = QH.LIST_HEADER_ID
830: AND QH.LIST_TYPE_CODE = 'PRL'
831: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
832: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE
966:
967:
968: CURSOR list_hdr_id(p_currency_code VARCHAR2) IS
969: SELECT QH.LIST_HEADER_ID
970: FROM QP_LIST_HEADERS_B QH
971: WHERE QH.LIST_TYPE_CODE = 'PRL'
972: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
973: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE
974: AND QH.mobile_download = 'Y'