DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 3951: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = l_line_loc_id);

3947: ELSE
3948:
3949: SELECT approved_flag INTO l_approved_flag
3950: FROM po_headers_all
3951: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = l_line_loc_id);
3952:
3953: IF(l_approved_flag = 'Y') THEN
3954: l_line_status := 'AWARD_APPROVED';
3955: ELSE

Line 4038: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = c_get_req_details_rec.LINE_LOCATION_ID);

4034: END;
4035: ELSE
4036: SELECT approved_flag INTO l_approved_flag
4037: FROM po_headers_all
4038: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = c_get_req_details_rec.LINE_LOCATION_ID);
4039:
4040: IF(l_approved_flag = 'Y') THEN
4041: l_line_status := 'AWARD_APPROVED';
4042: ELSE