DBA Data[Home] [Help]

APPS.QPR_DEAL_ETL dependencies on QPR_PN_REQUEST_HDRS_B

Line 790: insert into qpr_pn_request_hdrs_b (REQUEST_HEADER_ID,

786:
787: log_debug('Populating deal tables...');
788:
789: for c_int_header_rec in c_int_header loop
790: insert into qpr_pn_request_hdrs_b (REQUEST_HEADER_ID,
791: REQUEST_STATUS,
792: PN_INT_HEADER_ID,
793: INSTANCE_ID,
794: CURRENCY_SHORT_DESC,

Line 2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req

2405: if nvl(i_is_qty_changed, 'N') = 'Y' then
2406:
2407: select l.uom_code, req.instance_id,l.currency_code
2408: into l_uom_code, l_deal_instance, l_deal_currency
2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
2410: where l.pn_line_id = i_line_id
2411: and l.response_header_id = i_response_header_id
2412: and l.response_header_id = resp.response_header_id
2413: and resp.request_header_id = req.request_header_id