APPS.ICX_GET dependencies on PO_ACTION_HISTORY

Line 6: -- Function used to return the action dates from the PO_ACTION_HISTORY

2: /* $Header: ICXGETB.pls 115.6 2001/12/05 15:54:00 pkm ship $ */
3:
4: -- ***** GET_ACTION_HISTORY_DATE function *****
5:
6: -- Function used to return the action dates from the PO_ACTION_HISTORY
7: -- table for different action codes (approved, closed, etc.)
8: -- and object types (requisitions, purchase, etc.)
9:
10: FUNCTION get_action_history_date (x_object_id IN NUMBER,

Line 20: FROM PO_ACTION_HISTORY

16: BEGIN
17: /* Get the action date */
18: SELECT action_date
19: INTO x_action_date
20: FROM PO_ACTION_HISTORY
21: WHERE object_id = x_object_id
22: AND object_type_code like x_object_type_code
23: AND object_sub_type_code like x_subtype_code
24: AND action_code like x_action_code

Line 27: FROM PO_ACTION_HISTORY

23: AND object_sub_type_code like x_subtype_code
24: AND action_code like x_action_code
25: AND not exists
26: ( SELECT action_date
27: FROM PO_ACTION_HISTORY
28: WHERE object_id = x_object_id
29: AND object_type_code = x_object_type_code
30: AND object_sub_type_code = x_subtype_code
31: AND action_code is null);