DBA Data[Home] [Help]

APPS.ASO_PA_APR_INT dependencies on AME_ACTION_TYPES_VL

Line 81: from ame_action_types_vl

77:
78: /* Cursor to fetch Action type Desc */
79: cursor c_appr_action (l_value INTEGER) is
80: select USER_ACTION_TYPE_NAME
81: from ame_action_types_vl
82: where ACTION_TYPE_ID = l_value
83: and nvl(end_date,sysdate)>=trunc(sysdate);
84:
85: /* Cursor to fetch rule class id and rule category id */

Line 1900: from ame_action_types_vl

1896:
1897: /* Cursor to fetch Action type Desc */
1898: cursor c_appr_action (l_value INTEGER) is
1899: select USER_ACTION_TYPE_NAME
1900: from ame_action_types_vl
1901: where ACTION_TYPE_ID = l_value
1902: and nvl(end_date,sysdate)>=trunc(sysdate);
1903:
1904: l_approval_status varchar2(30);