APPS.AME_RUL_SHD dependencies on AME_CONDITION_USAGES

Line 387: from ame_condition_usages

383: and p_start_date between start_date and
384: nvl(end_date - ame_util.oneSecond, p_start_date);
385: Cursor C_Sel3 is
386: select count(*)
387: from ame_condition_usages
388: where rule_id = p_rule_id
389: and p_start_date between start_date and
390: nvl(end_date - ame_util.oneSecond, p_start_date);
391: --

Line 418: -- ame_condition_usages

414: fnd_message.set_token('TABLE_NAME','ame_action_usages');
415: hr_multi_message.add;
416: End If;
417: --
418: -- ame_condition_usages
419: Open C_Sel3;
420: Fetch C_Sel3 into l_child_count;
421: Close C_Sel3;
422: If l_child_count >0 then

Line 424: fnd_message.set_token('TABLE_NAME','ame_condition_usages');

420: Fetch C_Sel3 into l_child_count;
421: Close C_Sel3;
422: If l_child_count >0 then
423: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
424: fnd_message.set_token('TABLE_NAME','ame_condition_usages');
425: hr_multi_message.add;
426: End If;
427: --
428: --