DBA Data[Home] [Help]

APPS.JAI_AVLIST_VALIDATE_PKG dependencies on QP_LIST_HEADERS

Line 104: qp_list_headers

100: IS
101: SELECT
102: name
103: FROM
104: qp_list_headers
105: WHERE list_header_id = pn_list_header_id;
106:
107: -- Check same UOM ,whether item and item category that contains the same item existing in a same price list.
108: CURSOR check_item_category_cur

Line 196: lv_av_list_name qp_list_headers.name%type;

192: and a.list_header_id = pn_list_header_id;
193:
194: ln_excise_list_id NUMBER;
195: ln_vat_list_id NUMBER;
196: lv_av_list_name qp_list_headers.name%type;
197: ln_category_id NUMBER;
198: ln_category_count NUMBER; /* Added for bug 10103931 */
199: le_multi_row EXCEPTION;
200: