APPS.AME_RUL_SHD dependencies on AME_RULE_USAGES

Line 375: from ame_rule_usages

371: ) is
372: --
373: Cursor C_Sel1 is
374: select count(*)
375: from ame_rule_usages
376: where rule_id = p_rule_id
377: and p_start_date between start_date and
378: nvl(end_date - ame_util.oneSecond, p_start_date);
379: Cursor C_Sel2 is

Line 398: -- ame_rule_usages

394: --
395: Begin
396: --
397: --
398: -- ame_rule_usages
399: Open C_Sel1;
400: Fetch C_Sel1 into l_child_count;
401: Close C_Sel1;
402: If l_child_count >0 then

Line 404: fnd_message.set_token('TABLE_NAME','ame_rule_usages');

400: Fetch C_Sel1 into l_child_count;
401: Close C_Sel1;
402: If l_child_count >0 then
403: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
404: fnd_message.set_token('TABLE_NAME','ame_rule_usages');
405: hr_multi_message.add;
406: End If;
407: --
408: -- ame_action_usages