DBA Data[Home] [Help]

APPS.AME_ADMIN_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 4509: ame_mandatory_attributes

4505: select
4506: to_char(ame_attributes.start_date) start_date
4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and

Line 4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 4513: ame_mandatory_attributes.action_type_id = -1 and

4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)

Line 4516: sysdate between ame_mandatory_attributes.start_date and

4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;
4519: actionTypeIds ame_util.idList;
4520: applicationId integer;

Line 4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)

4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;
4519: actionTypeIds ame_util.idList;
4520: applicationId integer;
4521: attributeCount integer;