APPS.AME_ATY_SHD dependencies on AME_MANDATORY_ATTRIBUTES

Line 406: from ame_mandatory_attributes

402: nvl(end_date - ame_util.oneSecond, p_start_date);
403: --
404: Cursor C_Sel4 is
405: select count(*)
406: from ame_mandatory_attributes
407: where action_type_id = p_action_type_id and
408: p_start_date between start_date and
409: nvl(end_date - ame_util.oneSecond, p_start_date);
410: --

Line 449: -- ame_mandatory_attributes

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;
451: Fetch C_Sel4 into l_child_count;
452: Close C_Sel4;
453: If l_child_count > 0 then

Line 455: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');

451: Fetch C_Sel4 into l_child_count;
452: Close C_Sel4;
453: If l_child_count > 0 then
454: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
455: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');
456: hr_multi_message.add;
457: End If;
458: -- ame_action_type_config
459: Open C_Sel5;