APPS.PO_AGENTS_SV1 dependencies on PO_BUYERS_VAL_V

Line 20: /* get the agent_id by selecting employee_id from po_buyers_val_v

16: BEGIN
17:
18: X_progress := '010';
19:
20: /* get the agent_id by selecting employee_id from po_buyers_val_v
21: based on the agent_name provided from input parameter */
22:
23: SELECT employee_id
24: INTO X_agent_id_v

Line 25: FROM po_buyers_val_v

21: based on the agent_name provided from input parameter */
22:
23: SELECT employee_id
24: INTO X_agent_id_v
25: FROM po_buyers_val_v
26: WHERE full_name = X_agent_name;
27:
28: RETURN X_agent_id_v;
29:

Line 55: po_buyers_val_v table */

51: BEGIN
52: x_progress := '010';
53:
54: /* check to see if the given agnet_id is a valid agent_id in
55: po_buyers_val_v table */
56:
57: SELECT count(*)
58: INTO x_temp
59: FROM po_buyers_val_v

Line 59: FROM po_buyers_val_v

55: po_buyers_val_v table */
56:
57: SELECT count(*)
58: INTO x_temp
59: FROM po_buyers_val_v
60: WHERE employee_id = X_agent_id;
61:
62: IF x_temp = 0 THEN
63: RETURN FALSE; /* validation fails */