APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PON_AWARD_ALLOCATIONS

Line 2339: LINKED_PO_COUNT = Nvl(LINKED_PO_COUNT,0) + (SELECT Count(*) FROM pon_award_allocations paa1

2335: UPDATE po_requisition_lines_all prl
2336: SET PO_LINE_ID = -1,
2337: LINE_LOCATION_ID = -1,
2338: PO_DRAFT_ID = NULL,
2339: LINKED_PO_COUNT = Nvl(LINKED_PO_COUNT,0) + (SELECT Count(*) FROM pon_award_allocations paa1
2340: WHERE paa1.bid_number = l_bid_number
2341: AND paa1.IS_LINKED_PR_LINE_YN = 'Y'
2342: AND prl.REQUISITION_LINE_ID = paa1.ORIG_REQ_LINE_ID),
2343: last_update_date = SYSDATE,

Line 2347: FROM pon_award_allocations paa

2343: last_update_date = SYSDATE,
2344: last_updated_by = FND_GLOBAL.USER_ID,
2345: last_update_login = FND_GLOBAL.LOGIN_ID
2346: WHERE prl.REQUISITION_LINE_ID IN (SELECT paa.ORIG_REQ_LINE_ID
2347: FROM pon_award_allocations paa
2348: WHERE paa.bid_number = l_bid_number
2349: AND paa.IS_LINKED_PR_LINE_YN = 'Y')
2350: returning REQUISITION_LINE_ID BULK COLLECT INTO l_req_line_ids_tbl;
2351: