APPS.AME_ATY_SHD dependencies on AME_ACTION_TYPE_USAGES

Line 392: from ame_action_type_usages

388: nvl(end_date - ame_util.oneSecond, p_start_date);
389: --
390: Cursor C_Sel2 is
391: select count(*)
392: from ame_action_type_usages
393: where action_type_id = p_action_type_id and
394: p_start_date between start_date and
395: nvl(end_date - ame_util.oneSecond, p_start_date);
396: --

Line 431: -- ame_action_type_usages

427: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
428: fnd_message.set_token('TABLE_NAME','ame_actions');
429: hr_multi_message.add;
430: End If;
431: -- ame_action_type_usages
432: Open C_Sel2;
433: Fetch C_Sel2 into l_child_count;
434: Close C_Sel2;
435: If l_child_count > 0 then

Line 437: fnd_message.set_token('TABLE_NAME','ame_action_type_usages');

433: Fetch C_Sel2 into l_child_count;
434: Close C_Sel2;
435: If l_child_count > 0 then
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;