APPS.AME_APPROVER_GROUP_API dependencies on AME_APPROVAL_GROUPS

Line 53: from ame_approval_groups

49: start with approval_group_id = p_grp_id
50: connect by prior parameter = to_char(approval_group_id)
51: )
52: where not exists ( select approval_group_id
53: from ame_approval_groups
54: where approval_group_id = param
55: and param_name = 'OAM_group_id'
56: and is_static = 'Y'
57: and sysdate between start_date

Line 65: from ame_approval_Groups

61: select approval_group_id
62: ,'OAM_group_id'
63: ,to_char(approval_group_id)
64: ,1
65: from ame_approval_Groups
66: where approval_group_id=p_grp_id
67: and is_static = 'N'
68: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
69:

Line 134: from ame_approval_groups

130: end;
131: else
132: select query_string
133: into l_query_string
134: from ame_approval_groups
135: where to_char(approval_group_id) = r2.param
136: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
137: end if;
138:

Line 403: from ame_approval_groups

399: l_end_date_item date;
400: --cursor to find if the group has static members.
401: cursor Csel1 is
402: select is_static
403: from ame_approval_groups
404: where approval_group_id = p_approval_group_id
405: and sysdate >= start_date and sysdate < end_date;
406: --cursor to find the group's members.
407: cursor CSel3 is