APPS.AME_RUL_SHD dependencies on AME_ACTION_USAGES

Line 381: from ame_action_usages

377: and p_start_date between start_date and
378: nvl(end_date - ame_util.oneSecond, p_start_date);
379: Cursor C_Sel2 is
380: select count(*)
381: from ame_action_usages
382: where rule_id = p_rule_id
383: and p_start_date between start_date and
384: nvl(end_date - ame_util.oneSecond, p_start_date);
385: Cursor C_Sel3 is

Line 408: -- ame_action_usages

404: fnd_message.set_token('TABLE_NAME','ame_rule_usages');
405: hr_multi_message.add;
406: End If;
407: --
408: -- ame_action_usages
409: Open C_Sel2;
410: Fetch C_Sel2 into l_child_count;
411: Close C_Sel2;
412: If l_child_count >0 then

Line 414: fnd_message.set_token('TABLE_NAME','ame_action_usages');

410: Fetch C_Sel2 into l_child_count;
411: Close C_Sel2;
412: If l_child_count >0 then
413: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
414: fnd_message.set_token('TABLE_NAME','ame_action_usages');
415: hr_multi_message.add;
416: End If;
417: --
418: -- ame_condition_usages