DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on DUAL

Line 30: select to_number(p_grp_id) from dual;

26: and sysdate >= start_date and sysdate < end_date
27: start with parameter = to_char(p_grp_id)
28: connect by prior to_char(approval_group_id) = parameter
29: union
30: select to_number(p_grp_id) from dual;
31: --
32: -- given a group_id, this will find all members including the members within the nested groups too.
33: --
34: cursor c_expanded_nested_grps(p_grp_id number) is