APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 5228: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps

5224:
5225: WHEN l_progress_payment_type = 'FINANCE' AND recoupment_rate_percent IS NOT NULL
5226: AND target_price IS NOT NULL AND progress_pymt_rate_percent IS NOT NULL
5227: AND recoupment_rate_percent < (((((progress_pymt_rate_percent/100) * (SELECT nvl(sum(nvl(p_aps.target_price,0)*nvl(p_aps.quantity,nvl(s_quantity,1))),0)
5228: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps
5229: WHERE p_aps.auction_header_id=p_auction_header_id
5230: AND p_aps.line_number=s_line_number ))
5231: + NVL(advance_amount,0)) * 100)/((nvl(s_quantity, 1) * target_price))) THEN
5232: INTO pon_interface_errors

Line 5557: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai

5553: sysdate, -- LAST_UPDATE_DATE
5554: p_login_id, -- LAST_UPDATE_LOGIN
5555: p_request_id --REQUEST_ID
5556: FROM
5557: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai
5558: WHERE paps.auction_header_id=pai.auction_header_id
5559: AND paps.line_number = pai.line_number
5560: AND paps.auction_header_id = p_auction_header_id
5561: GROUP BY paps.auction_header_id, paps.line_number,

Line 5596: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,

5592: SELECT paps.payment_display_number, paps.payment_id,
5593: paps.project_id, paps.project_task_id, paps.project_expenditure_type,
5594: paps.project_exp_organization_id, paps.project_expenditure_item_date,
5595: paip.line_number, paip.document_disp_line_number
5596: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,
5597: PON_AUCTION_ITEM_PRICES_ALL paip
5598: WHERE paps.auction_header_id=p_auction_header_id
5599: AND paps.project_id IS NOT NULL
5600: AND paps.project_task_id IS NOT NULL

Line 5956: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,

5952: ppi.need_by_date,
5953: pah.close_bidding_date pah_close_bidding_date,
5954: pah.supplier_enterable_pymt_flag,
5955: pai.line_number s_line_number
5956: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
5957: PON_AUCTION_ITEM_PRICES_ALL pai,
5958: PON_AUCTION_HEADERS_ALL pah
5959: WHERE ppi.auction_header_id = pai.auction_header_id
5960: AND ppi.line_number = pai.line_number

Line 6144: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,

6140: ppi.auction_header_id auction_header_id,
6141: pai.document_disp_line_number,
6142: ppi.work_approver_user_id,
6143: pai.line_number s_line_number
6144: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
6145: PON_AUCTION_ITEM_PRICES_ALL pai,
6146: PON_AUCTION_HEADERS_ALL pah
6147: WHERE ppi.auction_header_id = pai.auction_header_id
6148: AND ppi.line_number = pai.line_number

Line 7112: FROM PON_AUC_PAYMENTS_SHIPMENTS

7108:
7109: --complex work - If the line has any payments this flag will be Y else N
7110: has_Payments_flag = NVL(
7111: (SELECT 'Y'
7112: FROM PON_AUC_PAYMENTS_SHIPMENTS
7113: WHERE AUCTION_HEADER_ID = p_auction_header_id
7114: AND LINE_NUMBER = PAIP.LINE_NUMBER
7115: AND ROWNUM = 1), 'N'),
7116:

Line 7377: UPDATE pon_auc_payments_shipments pay

7373: module => g_module_prefix || l_module_name,
7374: message => 'Update Payments Fields = ' || l_module_name);
7375: END IF;
7376:
7377: UPDATE pon_auc_payments_shipments pay
7378: SET
7379: SHIP_TO_LOCATION_ID = null,
7380: WORK_APPROVER_USER_ID = null,
7381: NOTE_TO_BIDDERS = null,