APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 6080: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps

6076:
6077: WHEN s_clm_info_flag = 'N' AND l_progress_payment_type = 'FINANCE' AND recoupment_rate_percent IS NOT NULL
6078: AND target_price IS NOT NULL AND progress_pymt_rate_percent IS NOT NULL
6079: 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)
6080: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps
6081: WHERE p_aps.auction_header_id=p_auction_header_id
6082: AND p_aps.line_number=s_line_number ))
6083: + NVL(advance_amount,0)) * 100)/((nvl(s_quantity, 1) * target_price))) THEN
6084: INTO pon_interface_errors

Line 6413: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai

6409: sysdate, -- LAST_UPDATE_DATE
6410: p_login_id, -- LAST_UPDATE_LOGIN
6411: p_request_id --REQUEST_ID
6412: FROM
6413: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai
6414: WHERE paps.auction_header_id=pai.auction_header_id
6415: AND paps.line_number = pai.line_number
6416: AND paps.auction_header_id = p_auction_header_id
6417: GROUP BY paps.auction_header_id, paps.line_number,

Line 6452: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,

6448: SELECT paps.payment_display_number, paps.payment_id,
6449: paps.project_id, paps.project_task_id, paps.project_expenditure_type,
6450: paps.project_exp_organization_id, paps.project_expenditure_item_date,
6451: paip.line_number, paip.document_disp_line_number
6452: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,
6453: PON_AUCTION_ITEM_PRICES_ALL paip
6454: WHERE paps.auction_header_id=p_auction_header_id
6455: AND paps.project_id IS NOT NULL
6456: AND paps.project_task_id IS NOT NULL

Line 6813: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,

6809: pah.close_bidding_date pah_close_bidding_date,
6810: pah.supplier_enterable_pymt_flag,
6811: pai.line_number s_line_number,
6812: pai.line_num_display
6813: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
6814: PON_AUCTION_ITEM_PRICES_ALL pai,
6815: PON_AUCTION_HEADERS_ALL pah
6816: WHERE ppi.auction_header_id = pai.auction_header_id
6817: AND ppi.line_number = pai.line_number

Line 7002: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,

6998: pai.document_disp_line_number,
6999: ppi.work_approver_user_id,
7000: pai.line_number s_line_number,
7001: pai.line_num_display
7002: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
7003: PON_AUCTION_ITEM_PRICES_ALL pai,
7004: PON_AUCTION_HEADERS_ALL pah
7005: WHERE ppi.auction_header_id = pai.auction_header_id
7006: AND ppi.line_number = pai.line_number

Line 8003: FROM PON_AUC_PAYMENTS_SHIPMENTS

7999:
8000: --complex work - If the line has any payments this flag will be Y else N
8001: has_Payments_flag = NVL(
8002: (SELECT 'Y'
8003: FROM PON_AUC_PAYMENTS_SHIPMENTS
8004: WHERE AUCTION_HEADER_ID = p_auction_header_id
8005: AND LINE_NUMBER = PAIP.LINE_NUMBER
8006: AND ROWNUM = 1), 'N'),
8007:

Line 8268: UPDATE pon_auc_payments_shipments pay

8264: module => g_module_prefix || l_module_name,
8265: message => 'Update Payments Fields = ' || l_module_name);
8266: END IF;
8267:
8268: UPDATE pon_auc_payments_shipments pay
8269: SET
8270: SHIP_TO_LOCATION_ID = null,
8271: WORK_APPROVER_USER_ID = null,
8272: NOTE_TO_BIDDERS = null,