APPS.AME_GPI_BUS dependencies on AME_APPROVAL_GROUPS

Line 124: from ame_approval_groups

120: cursor groupCursor is
121: select
122: approval_group_id
123: ,name
124: from ame_approval_groups
125: where
126: sysdate between start_date and (end_date - ame_util.oneSecond);
127: l_proc varchar2(72) := g_package||'get_allowed_nested_groups';
128: tempIndex number;

Line 316: from ame_approval_groups t

312: -- Cursor to find number of groups with approval_group_id = p_approval_Group_id and is_static='Y'
313: --
314: Cursor C_Sel1 Is
315: select count(t.approval_group_id)
316: from ame_approval_groups t
317: where t.approval_group_id = p_approval_group_id
318: and p_effective_date between t.start_date
319: and (t.end_date - ame_util.oneSecond);
320: Cursor C_Sel2 Is

Line 322: from ame_approval_groups t

318: and p_effective_date between t.start_date
319: and (t.end_date - ame_util.oneSecond);
320: Cursor C_Sel2 Is
321: select count(t.approval_group_id)
322: from ame_approval_groups t
323: where t.approval_group_id = p_approval_group_id
324: and t.is_static = 'Y'
325: and p_effective_date between t.start_date
326: and (t.end_date - ame_util.oneSecond);

Line 462: from ame_approval_groups t

458: -- Cursor to find number of groups with approval_group_id = p_parameter
459: --
460: Cursor C_Sel1 Is
461: select count(t.approval_group_id)
462: from ame_approval_groups t
463: where to_char(t.approval_group_id) = p_parameter
464: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
465:
466: Cursor C_Sel2 Is

Line 481: -- Check if the parameter corresponds to a valid group in ame_approval_groups

477: hr_api.mandatory_arg_error(p_api_name => l_proc
478: ,p_argument => 'PARAMETER'
479: ,p_argument_value => p_parameter
480: );
481: -- Check if the parameter corresponds to a valid group in ame_approval_groups
482: -- whenever parameter_name = 'OAM_group_id'
483: -- If parameter_name = 'wf_roles_name' then validate the wf_roles_name.
484: --
485: if p_parameter_name = ame_util.approverOamGroupId then