APPS.AME_ATY_SHD dependencies on AME_APPROVER_TYPE_USAGES

Line 399: from ame_approver_type_usages

395: nvl(end_date - ame_util.oneSecond, p_start_date);
396: --
397: Cursor C_Sel3 is
398: select count(*)
399: from ame_approver_type_usages
400: where action_type_id = p_action_type_id and
401: p_start_date between start_date and
402: nvl(end_date - ame_util.oneSecond, p_start_date);
403: --

Line 440: -- ame_approver_type_usages

436: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
437: fnd_message.set_token('TABLE_NAME','ame_action_type_usages');
438: hr_multi_message.add;
439: End If;
440: -- ame_approver_type_usages
441: Open C_Sel3;
442: Fetch C_Sel3 into l_child_count;
443: Close C_Sel3;
444: If l_child_count > 0 then

Line 446: fnd_message.set_token('TABLE_NAME','ame_approver_type_usages');

442: Fetch C_Sel3 into l_child_count;
443: Close C_Sel3;
444: If l_child_count > 0 then
445: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
446: fnd_message.set_token('TABLE_NAME','ame_approver_type_usages');
447: hr_multi_message.add;
448: End If;
449: -- ame_mandatory_attributes
450: Open C_Sel4;