APPS.AME_AGL_BUS dependencies on AME_APPROVAL_GROUPS

Line 49: from ame_approval_groups

45: l_proc varchar2(72) := g_package || 'chk_approval_group_id';
46: l_count number;
47: cursor CSel1 is
48: select count(*)
49: from ame_approval_groups
50: where approval_group_id = p_approval_group_id
51: and sysdate >= start_date and sysdate < end_date;
52: Begin
53: hr_utility.set_location('Entering:'||l_proc,10);

Line 70: 'AME_APPROVAL_GROUPS_TL.APPROVAL_GROUP_ID'

66: exception
67: when app_exception.application_exception then
68: if hr_multi_message.exception_add
69: (p_associated_column1 =>
70: 'AME_APPROVAL_GROUPS_TL.APPROVAL_GROUP_ID'
71: ) then
72: hr_utility.set_location(' Leaving:'||l_proc, 40);
73: raise;
74: end if;

Line 119: 'AME_APPROVAL_GROUPS_TL.USER_APPROVAL_GROUP_NAME'

115: exception
116: when app_exception.application_exception then
117: if hr_multi_message.exception_add
118: (p_associated_column1 =>
119: 'AME_APPROVAL_GROUPS_TL.USER_APPROVAL_GROUP_NAME'
120: ) then
121: hr_utility.set_location(' Leaving:'||l_proc, 40);
122: raise;
123: end if;

Line 168: 'AME_APPROVAL_GROUPS_TL.DESCRIPTION'

164: exception
165: when app_exception.application_exception then
166: if hr_multi_message.exception_add
167: (p_associated_column1 =>
168: 'AME_APPROVAL_GROUPS_TL.DESCRIPTION'
169: ) then
170: hr_utility.set_location(' Leaving:'||l_proc, 40);
171: raise;
172: end if;