APPS.PO_REQ_LINES_SV1 dependencies on PO_BUYERS_VAL_V

Line 53: /* Bug - 1921406 - Changed the sql to use po_buyers_val_v

49: x_progress := '040';
50:
51: IF (x_buyer_id is not null) THEN
52:
53: /* Bug - 1921406 - Changed the sql to use po_buyers_val_v
54: instead of po_buyers_all_v, because po_buyers_all_v has no
55: effectivity dates and hence returns multiple rows. */
56:
57: /* Bug 2779096 : added exception handler to the following

Line 59: exist in po_buyers_val_v we we assign null */

55: effectivity dates and hence returns multiple rows. */
56:
57: /* Bug 2779096 : added exception handler to the following
58: select so that if the buyer id is not valid and does not
59: exist in po_buyers_val_v we we assign null */
60:
61: begin
62: SELECT full_name
63: INTO x_buyer

Line 64: FROM po_buyers_val_v

60:
61: begin
62: SELECT full_name
63: INTO x_buyer
64: FROM po_buyers_val_v
65: WHERE employee_id = x_buyer_id;
66: exception
67: when others then
68: x_buyer := null;