APPS.QP_INT_LOADER_PUB dependencies on QP_INTERFACE_LIST_HEADERS

Line 232: FROM qp_interface_list_headers

228:
229: -- obtain values for validations
230: SELECT process_type, list_type_code, interface_action_code, name, source_system_code
231: INTO l_process_type, l_list_type_code, l_interface_action_code, l_name, l_request_type_code
232: FROM qp_interface_list_headers
233: WHERE process_id = p_process_id;
234:
235: QP_INT_LOADER_PUB.G_PROCESS_LST_REQ_TYPE := nvl(l_request_type_code, 'FTE'); --shulin, used in BOI
236:

Line 313: qp_interface_list_headers lhdr

309: gpr_price_list_rec.start_date_active,
310: gpr_price_list_rec.end_date_active,
311: gpr_price_list_rec.automatic_flag
312: FROM
313: qp_interface_list_headers lhdr
314: WHERE
315: lhdr.process_id = p_process_id
316: AND
317: rownum < 2;

Line 343: qp_interface_list_headers lhdr

339: gpr_modifier_list_rec.start_date_active,
340: gpr_modifier_list_rec.end_date_active,
341: gpr_modifier_list_rec.automatic_flag
342: FROM
343: qp_interface_list_headers lhdr
344: WHERE
345: lhdr.process_id = p_process_id
346: AND
347: rownum < 2;

Line 372: qp_interface_list_headers lhdr

368: gpr_price_list_rec.start_date_active,
369: gpr_price_list_rec.end_date_active,
370: gpr_price_list_rec.automatic_flag
371: FROM
372: qp_interface_list_headers lhdr
373: WHERE
374: lhdr.process_id = p_process_id
375: AND
376: rownum < 2;

Line 403: qp_interface_list_headers lhdr

399: gpr_modifier_list_rec.start_date_active,
400: gpr_modifier_list_rec.end_date_active,
401: gpr_modifier_list_rec.automatic_flag
402: FROM
403: qp_interface_list_headers lhdr
404: WHERE
405: lhdr.process_id = p_process_id
406: AND
407: rownum < 2;