APPS.AME_APPROVAL_GROUP_PKG dependencies on AME_ACTION_USAGES

Line 650: ame_action_usages

646: into useCount
647: from
648: ame_actions,
649: ame_action_types,
650: ame_action_usages
651: where
652: ame_actions.parameter = to_char(approvalGroupIdIn) and
653: ame_action_usages.action_id = ame_actions.action_id and
654: ame_actions.action_type_id = ame_action_types.action_type_id and

Line 653: ame_action_usages.action_id = ame_actions.action_id and

649: ame_action_types,
650: ame_action_usages
651: where
652: ame_actions.parameter = to_char(approvalGroupIdIn) and
653: ame_action_usages.action_id = ame_actions.action_id and
654: ame_actions.action_type_id = ame_action_types.action_type_id and
655: ame_action_types.name in (ame_util.preApprovalTypeName,
656: ame_util.postApprovalTypeName,
657: ame_util.groupChainApprovalTypeName) and

Line 662: ((sysdate between ame_action_usages.start_date and

658: sysdate between ame_actions.start_date and
659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
660: sysdate between ame_action_types.start_date and
661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
666: ame_action_usages.start_date + ame_util.oneSecond)));

Line 663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

659: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
660: sysdate between ame_action_types.start_date and
661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
666: ame_action_usages.start_date + ame_util.oneSecond)));
667: if(useCount > 0) then

Line 664: (sysdate < ame_action_usages.start_date and

660: sysdate between ame_action_types.start_date and
661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
666: ame_action_usages.start_date + ame_util.oneSecond)));
667: if(useCount > 0) then
668: return(true);

Line 665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

661: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
666: ame_action_usages.start_date + ame_util.oneSecond)));
667: if(useCount > 0) then
668: return(true);
669: end if;

Line 666: ame_action_usages.start_date + ame_util.oneSecond)));

662: ((sysdate between ame_action_usages.start_date and
663: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
664: (sysdate < ame_action_usages.start_date and
665: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
666: ame_action_usages.start_date + ame_util.oneSecond)));
667: if(useCount > 0) then
668: return(true);
669: end if;
670: return(false);