APPS.AHL_OSP_RCV_PVT dependencies on FND_PROFILE

Line 212: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

208: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
209: SELECT 'X'
210: FROM OE_ORDER_LINES_ALL
211: WHERE line_id = c_oe_line_id
212: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
213:
214: -- SATHAPLI::Bug 6877509 - changes start, 02-Apr-08
215: -- Cursor to get the ordered and shipped quantities of the given return line.
216: -- If the return line has been split (like in partial qty receive for non-serialized items), we have to look at

Line 534: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

530: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
531: SELECT 'X'
532: FROM OE_ORDER_LINES_ALL
533: WHERE line_id = c_oe_line_id
534: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
535:
536: -- Cursor to check whether the shipment is booked or not.
537: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
538: SELECT OHA.header_id

Line 2284: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

2280: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
2281: SELECT 'X'
2282: FROM OE_ORDER_LINES_ALL
2283: WHERE line_id = c_oe_line_id
2284: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
2285:
2286: -- Cursor to check whether the shipment is booked or not.
2287: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
2288: SELECT OHA.header_id