APPS.AME_APPROVER_TYPE_PKG dependencies on AME_ACTION_TYPES

Line 1118: ame_action_types,

1114: actionTypeNamesOut out nocopy ame_util.stringList) as
1115: cursor getApprovalTypeCursor is
1116: select name
1117: from
1118: ame_action_types,
1119: ame_approver_type_usages
1120: where
1121: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1122: approver_type_id = approverTypeIdIn and

Line 1121: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and

1117: from
1118: ame_action_types,
1119: ame_approver_type_usages
1120: where
1121: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1122: approver_type_id = approverTypeIdIn and
1123: sysdate between ame_action_types.start_date and
1124: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1125: sysdate between ame_approver_type_usages.start_date and

Line 1123: sysdate between ame_action_types.start_date and

1119: ame_approver_type_usages
1120: where
1121: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1122: approver_type_id = approverTypeIdIn and
1123: sysdate between ame_action_types.start_date and
1124: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1125: sysdate between ame_approver_type_usages.start_date and
1126: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1127: cursor getApprovalTypeCursor2 is

Line 1124: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1120: where
1121: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1122: approver_type_id = approverTypeIdIn and
1123: sysdate between ame_action_types.start_date and
1124: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1125: sysdate between ame_approver_type_usages.start_date and
1126: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1127: cursor getApprovalTypeCursor2 is
1128: select name

Line 1130: ame_action_types,

1126: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1127: cursor getApprovalTypeCursor2 is
1128: select name
1129: from
1130: ame_action_types,
1131: ame_approver_type_usages
1132: where
1133: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1134: approver_type_id = ame_util.anyApproverType and

Line 1133: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and

1129: from
1130: ame_action_types,
1131: ame_approver_type_usages
1132: where
1133: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1134: approver_type_id = ame_util.anyApproverType and
1135: sysdate between ame_action_types.start_date and
1136: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1137: sysdate between ame_approver_type_usages.start_date and

Line 1135: sysdate between ame_action_types.start_date and

1131: ame_approver_type_usages
1132: where
1133: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1134: approver_type_id = ame_util.anyApproverType and
1135: sysdate between ame_action_types.start_date and
1136: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1137: sysdate between ame_approver_type_usages.start_date and
1138: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1139: tempIndex integer;

Line 1136: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1132: where
1133: ame_action_types.action_type_id = ame_approver_type_usages.action_type_id and
1134: approver_type_id = ame_util.anyApproverType and
1135: sysdate between ame_action_types.start_date and
1136: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1137: sysdate between ame_approver_type_usages.start_date and
1138: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate);
1139: tempIndex integer;
1140: begin