APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;

412: x_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%type ;
413: x_job_id po_requisition_lines_all.JOB_ID%type;
414: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
415: x_line_num po_requisition_lines_all.line_num%TYPE;
416: x_neg_line_num_disp pon_auction_item_prices_all.line_num_display%TYPE;
417:
418: -- added for CLIN SLIN Project
419: x_line_num_display po_requisition_lines_all.line_num_display%TYPE;
420: x_group_line_id po_requisition_lines_all.group_line_id%TYPE;

Line 2536: select uda_template_id into l_line_uda_temp_id from pon_auction_item_prices_all

2532: fnd_log.string(fnd_log.level_statement,g_log_head,'l_contract_type : '||l_contract_type);
2533: END IF;
2534:
2535: begin
2536: select uda_template_id into l_line_uda_temp_id from pon_auction_item_prices_all
2537: where auction_header_id = p_auction_header_id and rownum <2;
2538:
2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2540: fnd_log.string(fnd_log.level_statement,g_log_head,'l_line_uda_temp_id : '||l_line_uda_temp_id);

Line 3783: FROM pon_auction_item_prices_ALL

3779: SELECT requisition_line_id
3780: FROM pon_backing_requisitions
3781: WHERE auction_header_id = p_auction_header_id
3782: AND EXISTS ( SELECT line_number
3783: FROM pon_auction_item_prices_ALL
3784: WHERE auction_header_id = p_auction_header_id
3785: AND (line_number = p_auction_line_number
3786: OR group_line_id = p_auction_line_number))
3787: GROUP BY requisition_line_id;